{"Entry":{"collection":"func","key":"pg-get-multixact-members","name":"pg_get_multixact_members","aliases":[],"metadata":{"changed_in":[],"changes":[{"descriptions_changed":false,"doc_overhaul":false,"from":"12","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"added","to":"13"}],"content_hash":"b6f553a403120e8e53f3afd84444eaeaf0e5c04cbeb29da79b3238dceae98af5","derived_content_hash":"bff06e127efd7758f5c359e39a5d325bbfba74fd3901a2cc401b54f9558382aa","documentation_refresh":{"batch":"20261113","original_source_rev":"wiki-repair-20261023:81749b73a891c2bdd3b68e82be21f586d87f0ba5ae8f41d6453100ac56c5e634","versions":{"14":"14.25","15":"15.20","16":"16.16","17":"17.12","18":"18.7","19":"19rc2"}},"first_version":"13","group":"info","group_label":"System Information Functions And Operators","groups":["info"],"imported_at":"2026-09-27T17:57:29.193548+08:00","last_version":"20","name":"pg_get_multixact_members","name_key":"pg_get_multixact_members","position":28064,"present_in":["13","14","15","16","17","18","19","20"],"repair_provenance":{"original_source_revision":"b7bd9cda","receipt_sha256":"8d25adcc720317f45fe2f13742991bf83d169807038fbcf8c602701957847127","repair":"wiki-repair-20261023"},"signature":"pg_get_multixact_members ( multixid xid ) → setof record ( xid xid, mode text )","signature_count":1,"slug":"pg-get-multixact-members","source_rev":"wiki-repair-20261023:81749b73a891c2bdd3b68e82be21f586d87f0ba5ae8f41d6453100ac56c5e634","summary":"Returns the transaction ID and lock mode for each member of the specified multixact ID.","summary_zh":""}},"Definition":{"Collection":"func","Key":"pg-get-multixact-members","SourceDatabase":"center","Version":"18","SourceTable":"func","SourceKey":"pg-get-multixact-members","SourceRevision":"wiki-repair-20261023:81749b73a891c2bdd3b68e82be21f586d87f0ba5ae8f41d6453100ac56c5e634","Facts":{"description":"Returns the transaction ID and lock mode for each member of the specified multixact ID. The lock modes forupd, fornokeyupd, sh, and keysh correspond to the row-level locks FOR UPDATE, FOR NO KEY UPDATE, FOR SHARE, and FOR KEY SHARE, respectively, as described in Section 13.3.2. Two additional modes are specific to multixacts: nokeyupd, used by updates that do not modify key columns, and upd, used by updates or deletes that modify key columns.","description_html":"Returns the transaction ID and lock mode for each member of the specified multixact ID. The lock modes \u003ccode class=\"literal\"\u003eforupd\u003c/code\u003e, \u003ccode class=\"literal\"\u003efornokeyupd\u003c/code\u003e, \u003ccode class=\"literal\"\u003esh\u003c/code\u003e, and \u003ccode class=\"literal\"\u003ekeysh\u003c/code\u003e correspond to the row-level locks \u003ccode class=\"literal\"\u003eFOR UPDATE\u003c/code\u003e, \u003ccode class=\"literal\"\u003eFOR NO KEY UPDATE\u003c/code\u003e, \u003ccode class=\"literal\"\u003eFOR SHARE\u003c/code\u003e, and \u003ccode class=\"literal\"\u003eFOR KEY SHARE\u003c/code\u003e, respectively, as described in \u003ca href=\"/docs/18/explicit-locking.html#LOCKING-ROWS\" title=\"13.3.2. Row-Level Locks\"\u003eSection 13.3.2\u003c/a\u003e. Two additional modes are specific to multixacts: \u003ccode class=\"literal\"\u003enokeyupd\u003c/code\u003e, used by updates that do not modify key columns, and \u003ccode class=\"literal\"\u003eupd\u003c/code\u003e, used by updates or deletes that modify key columns.","description_zh":"返回指定多事务 ID 中每个成员的事务 ID 和锁模式。锁模式 forupd、fornokeyupd、sh 和 keysh 分别对应于第 13.3.2 节中描述的行级锁 FOR UPDATE、FOR NO KEY UPDATE、FOR SHARE 和 FOR KEY SHARE。另有两种多事务特有的模式：nokeyupd 用于不修改键列的更新，upd 用于修改键列的更新或删除。","description_zh_html":"返回指定多事务 ID 中每个成员的事务 ID 和锁模式。锁模式 \u003ccode class=\"literal\"\u003eforupd\u003c/code\u003e、\u003ccode class=\"literal\"\u003efornokeyupd\u003c/code\u003e、\u003ccode class=\"literal\"\u003esh\u003c/code\u003e 和 \u003ccode class=\"literal\"\u003ekeysh\u003c/code\u003e 分别对应于\u003ca href=\"/docs/18/explicit-locking.html#LOCKING-ROWS\" title=\"13.3.2. 行级锁\"\u003e第 13.3.2 节\u003c/a\u003e中描述的行级锁 \u003ccode class=\"literal\"\u003eFOR UPDATE\u003c/code\u003e、\u003ccode class=\"literal\"\u003eFOR NO KEY UPDATE\u003c/code\u003e、\u003ccode class=\"literal\"\u003eFOR SHARE\u003c/code\u003e 和 \u003ccode class=\"literal\"\u003eFOR KEY SHARE\u003c/code\u003e。另有两种多事务特有的模式：\u003ccode class=\"literal\"\u003enokeyupd\u003c/code\u003e 用于不修改键列的更新，\u003ccode class=\"literal\"\u003eupd\u003c/code\u003e 用于修改键列的更新或删除。","doc":{"anchor":"FUNCTIONS-PG-SNAPSHOT","file":"functions-info.html","sha256":"64499116227a087138bb14f29ff6652b200a176d5df3ce2a089c3d5c226b19b3","slug":"18"},"documentation_revision":{"inputs":[{"file":"functions-info.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"64499116227a087138bb14f29ff6652b200a176d5df3ce2a089c3d5c226b19b3","version":"18.7"},{"file":"functions-info.html","kind":"same-version-reviewed-manual","locale":"zh-Hans","sha256":"f9684137c0b9fb17a691c4d905529d114472a507a007c15058f2703962b611d2","version":"18.7"}],"release":"18.7","runtime_remeasured":false,"source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552"},"group":"info","group_label":"系统信息函数和操作符","lang":"en","layout":"table-new","pages":["functions-info.html"],"prose_only":false,"signatures":[{"description":"Returns the transaction ID and lock mode for each member of the specified multixact ID. The lock modes forupd, fornokeyupd, sh, and keysh correspond to the row-level locks FOR UPDATE, FOR NO KEY UPDATE, FOR SHARE, and FOR KEY SHARE, respectively, as described in Section 13.3.2. Two additional modes are specific to multixacts: nokeyupd, used by updates that do not modify key columns, and upd, used by updates or deletes that modify key columns.","description_html":"Returns the transaction ID and lock mode for each member of the specified multixact ID. The lock modes \u003ccode class=\"literal\"\u003eforupd\u003c/code\u003e, \u003ccode class=\"literal\"\u003efornokeyupd\u003c/code\u003e, \u003ccode class=\"literal\"\u003esh\u003c/code\u003e, and \u003ccode class=\"literal\"\u003ekeysh\u003c/code\u003e correspond to the row-level locks \u003ccode class=\"literal\"\u003eFOR UPDATE\u003c/code\u003e, \u003ccode class=\"literal\"\u003eFOR NO KEY UPDATE\u003c/code\u003e, \u003ccode class=\"literal\"\u003eFOR SHARE\u003c/code\u003e, and \u003ccode class=\"literal\"\u003eFOR KEY SHARE\u003c/code\u003e, respectively, as described in \u003ca href=\"/docs/18/explicit-locking.html#LOCKING-ROWS\" title=\"13.3.2. Row-Level Locks\"\u003eSection 13.3.2\u003c/a\u003e. Two additional modes are specific to multixacts: \u003ccode class=\"literal\"\u003enokeyupd\u003c/code\u003e, used by updates that do not modify key columns, and \u003ccode class=\"literal\"\u003eupd\u003c/code\u003e, used by updates or deletes that modify key columns.","description_zh":"返回指定多事务 ID 中每个成员的事务 ID 和锁模式。锁模式 forupd、fornokeyupd、sh 和 keysh 分别对应于第 13.3.2 节中描述的行级锁 FOR UPDATE、FOR NO KEY UPDATE、FOR SHARE 和 FOR KEY SHARE。另有两种多事务特有的模式：nokeyupd 用于不修改键列的更新，upd 用于修改键列的更新或删除。","description_zh_html":"返回指定多事务 ID 中每个成员的事务 ID 和锁模式。锁模式 \u003ccode class=\"literal\"\u003eforupd\u003c/code\u003e、\u003ccode class=\"literal\"\u003efornokeyupd\u003c/code\u003e、\u003ccode class=\"literal\"\u003esh\u003c/code\u003e 和 \u003ccode class=\"literal\"\u003ekeysh\u003c/code\u003e 分别对应于\u003ca href=\"/docs/18/explicit-locking.html#LOCKING-ROWS\" title=\"13.3.2. 行级锁\"\u003e第 13.3.2 节\u003c/a\u003e中描述的行级锁 \u003ccode class=\"literal\"\u003eFOR UPDATE\u003c/code\u003e、\u003ccode class=\"literal\"\u003eFOR NO KEY UPDATE\u003c/code\u003e、\u003ccode class=\"literal\"\u003eFOR SHARE\u003c/code\u003e 和 \u003ccode class=\"literal\"\u003eFOR KEY SHARE\u003c/code\u003e。另有两种多事务特有的模式：\u003ccode class=\"literal\"\u003enokeyupd\u003c/code\u003e 用于不修改键列的更新，\u003ccode class=\"literal\"\u003eupd\u003c/code\u003e 用于修改键列的更新或删除。","examples":[],"html":"\u003ccode class=\"function\"\u003epg_get_multixact_members\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003emultixid\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003exid\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003esetof record\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003exid\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003exid\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003emode\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etext\u003c/code\u003e )","returns":"setof record","text":"pg_get_multixact_members ( multixid xid ) → setof record ( xid xid, mode text )","zh_from":"same-version-manual"}],"translation_provenance":{"inputs":[{"kind":"current-pgdoc-translation","path":"/Users/vonng/pgsty/pgdoc/zh/18/html/functions-info.html","sha256":"7c33185e79430cfbda432dc4db277115c7ac846afccadfcf904ceb1bf2aa1ba5"}],"kind":"same-version-pgdoc","locale":"zh-Hans","source_revision":"b1b500221dbe5437cfca004d6b04d3f6e422765d","version":"18"},"zh_from":"same-version-manual"},"ManualEvidence":{"doc":{"anchor":"FUNCTIONS-PG-SNAPSHOT","file":"functions-info.html","sha256":"64499116227a087138bb14f29ff6652b200a176d5df3ce2a089c3d5c226b19b3","slug":"18"}},"MeasuredEvidence":{}},"Text":{"Collection":"func","Key":"pg-get-multixact-members","SourceDatabase":"center","Version":"18","Locale":"en","Title":"pg_get_multixact_members","Summary":"Returns the transaction ID and lock mode for each member of the specified multixact ID. The lock modes forupd, fornokeyupd, sh, and keysh correspond to the row-level locks FOR UPDATE, FOR NO KEY UPDATE, FOR SHARE, and FOR KEY SHARE, respectively, as described in Section 13.3.2. Two additional modes are specific to multixacts: nokeyupd, used by updates that do not modify key columns, and upd, used by updates or deletes that modify key columns.","BodyHTML":"Returns the transaction ID and lock mode for each member of the specified multixact ID. The lock modes \u003ccode\u003eforupd\u003c/code\u003e, \u003ccode\u003efornokeyupd\u003c/code\u003e, \u003ccode\u003esh\u003c/code\u003e, and \u003ccode\u003ekeysh\u003c/code\u003e correspond to the row-level locks \u003ccode\u003eFOR UPDATE\u003c/code\u003e, \u003ccode\u003eFOR NO KEY UPDATE\u003c/code\u003e, \u003ccode\u003eFOR SHARE\u003c/code\u003e, and \u003ccode\u003eFOR KEY SHARE\u003c/code\u003e, respectively, as described in \u003ca href=\"/docs/18/explicit-locking.html#LOCKING-ROWS\" rel=\"nofollow\"\u003eSection 13.3.2\u003c/a\u003e. Two additional modes are specific to multixacts: \u003ccode\u003enokeyupd\u003c/code\u003e, used by updates that do not modify key columns, and \u003ccode\u003eupd\u003c/code\u003e, used by updates or deletes that modify key columns.","SourceRevision":"wiki-repair-20261023:81749b73a891c2bdd3b68e82be21f586d87f0ba5ae8f41d6453100ac56c5e634","ContentHash":"3a8f7001846b0e47763fe5f5743f36cc7379c34ab4eac19b434118782371617b","Payload":{"description":"Returns the transaction ID and lock mode for each member of the specified multixact ID. The lock modes forupd, fornokeyupd, sh, and keysh correspond to the row-level locks FOR UPDATE, FOR NO KEY UPDATE, FOR SHARE, and FOR KEY SHARE, respectively, as described in Section 13.3.2. Two additional modes are specific to multixacts: nokeyupd, used by updates that do not modify key columns, and upd, used by updates or deletes that modify key columns.","description_html":"Returns the transaction ID and lock mode for each member of the specified multixact ID. The lock modes \u003ccode class=\"literal\"\u003eforupd\u003c/code\u003e, \u003ccode class=\"literal\"\u003efornokeyupd\u003c/code\u003e, \u003ccode class=\"literal\"\u003esh\u003c/code\u003e, and \u003ccode class=\"literal\"\u003ekeysh\u003c/code\u003e correspond to the row-level locks \u003ccode class=\"literal\"\u003eFOR UPDATE\u003c/code\u003e, \u003ccode class=\"literal\"\u003eFOR NO KEY UPDATE\u003c/code\u003e, \u003ccode class=\"literal\"\u003eFOR SHARE\u003c/code\u003e, and \u003ccode class=\"literal\"\u003eFOR KEY SHARE\u003c/code\u003e, respectively, as described in \u003ca href=\"/docs/18/explicit-locking.html#LOCKING-ROWS\" title=\"13.3.2. Row-Level Locks\"\u003eSection 13.3.2\u003c/a\u003e. Two additional modes are specific to multixacts: \u003ccode class=\"literal\"\u003enokeyupd\u003c/code\u003e, used by updates that do not modify key columns, and \u003ccode class=\"literal\"\u003eupd\u003c/code\u003e, used by updates or deletes that modify key columns.","signatures":[{"description":"Returns the transaction ID and lock mode for each member of the specified multixact ID. The lock modes forupd, fornokeyupd, sh, and keysh correspond to the row-level locks FOR UPDATE, FOR NO KEY UPDATE, FOR SHARE, and FOR KEY SHARE, respectively, as described in Section 13.3.2. Two additional modes are specific to multixacts: nokeyupd, used by updates that do not modify key columns, and upd, used by updates or deletes that modify key columns.","description_html":"Returns the transaction ID and lock mode for each member of the specified multixact ID. The lock modes \u003ccode class=\"literal\"\u003eforupd\u003c/code\u003e, \u003ccode class=\"literal\"\u003efornokeyupd\u003c/code\u003e, \u003ccode class=\"literal\"\u003esh\u003c/code\u003e, and \u003ccode class=\"literal\"\u003ekeysh\u003c/code\u003e correspond to the row-level locks \u003ccode class=\"literal\"\u003eFOR UPDATE\u003c/code\u003e, \u003ccode class=\"literal\"\u003eFOR NO KEY UPDATE\u003c/code\u003e, \u003ccode class=\"literal\"\u003eFOR SHARE\u003c/code\u003e, and \u003ccode class=\"literal\"\u003eFOR KEY SHARE\u003c/code\u003e, respectively, as described in \u003ca href=\"/docs/18/explicit-locking.html#LOCKING-ROWS\" title=\"13.3.2. Row-Level Locks\"\u003eSection 13.3.2\u003c/a\u003e. Two additional modes are specific to multixacts: \u003ccode class=\"literal\"\u003enokeyupd\u003c/code\u003e, used by updates that do not modify key columns, and \u003ccode class=\"literal\"\u003eupd\u003c/code\u003e, used by updates or deletes that modify key columns.","description_zh":"返回指定多事务 ID 中每个成员的事务 ID 和锁模式。锁模式 forupd、fornokeyupd、sh 和 keysh 分别对应于第 13.3.2 节中描述的行级锁 FOR UPDATE、FOR NO KEY UPDATE、FOR SHARE 和 FOR KEY SHARE。另有两种多事务特有的模式：nokeyupd 用于不修改键列的更新，upd 用于修改键列的更新或删除。","description_zh_html":"返回指定多事务 ID 中每个成员的事务 ID 和锁模式。锁模式 \u003ccode class=\"literal\"\u003eforupd\u003c/code\u003e、\u003ccode class=\"literal\"\u003efornokeyupd\u003c/code\u003e、\u003ccode class=\"literal\"\u003esh\u003c/code\u003e 和 \u003ccode class=\"literal\"\u003ekeysh\u003c/code\u003e 分别对应于\u003ca href=\"/docs/18/explicit-locking.html#LOCKING-ROWS\" title=\"13.3.2. 行级锁\"\u003e第 13.3.2 节\u003c/a\u003e中描述的行级锁 \u003ccode class=\"literal\"\u003eFOR UPDATE\u003c/code\u003e、\u003ccode class=\"literal\"\u003eFOR NO KEY UPDATE\u003c/code\u003e、\u003ccode class=\"literal\"\u003eFOR SHARE\u003c/code\u003e 和 \u003ccode class=\"literal\"\u003eFOR KEY SHARE\u003c/code\u003e。另有两种多事务特有的模式：\u003ccode class=\"literal\"\u003enokeyupd\u003c/code\u003e 用于不修改键列的更新，\u003ccode class=\"literal\"\u003eupd\u003c/code\u003e 用于修改键列的更新或删除。","examples":[],"html":"\u003ccode class=\"function\"\u003epg_get_multixact_members\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003emultixid\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003exid\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003esetof record\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003exid\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003exid\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003emode\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etext\u003c/code\u003e )","returns":"setof record","text":"pg_get_multixact_members ( multixid xid ) → setof record ( xid xid, mode text )","zh_from":"same-version-manual"}]}},"RequestedLocale":"en","Fallback":false,"Versions":["13","14","15","16","17","18","19","20"],"Locales":["en","zh-Hans"],"Signatures":[{"Version":"18","Ordinal":0,"Hash":"0f670072139032b8ce00edf740b40fc46ae39af7c353229321baa38050f67e6c","Text":"pg_get_multixact_members ( multixid xid ) → setof record ( xid xid, mode text )","Returns":"setof record","Payload":{"description":"Returns the transaction ID and lock mode for each member of the specified multixact ID. The lock modes forupd, fornokeyupd, sh, and keysh correspond to the row-level locks FOR UPDATE, FOR NO KEY UPDATE, FOR SHARE, and FOR KEY SHARE, respectively, as described in Section 13.3.2. Two additional modes are specific to multixacts: nokeyupd, used by updates that do not modify key columns, and upd, used by updates or deletes that modify key columns.","description_html":"Returns the transaction ID and lock mode for each member of the specified multixact ID. The lock modes \u003ccode class=\"literal\"\u003eforupd\u003c/code\u003e, \u003ccode class=\"literal\"\u003efornokeyupd\u003c/code\u003e, \u003ccode class=\"literal\"\u003esh\u003c/code\u003e, and \u003ccode class=\"literal\"\u003ekeysh\u003c/code\u003e correspond to the row-level locks \u003ccode class=\"literal\"\u003eFOR UPDATE\u003c/code\u003e, \u003ccode class=\"literal\"\u003eFOR NO KEY UPDATE\u003c/code\u003e, \u003ccode class=\"literal\"\u003eFOR SHARE\u003c/code\u003e, and \u003ccode class=\"literal\"\u003eFOR KEY SHARE\u003c/code\u003e, respectively, as described in \u003ca href=\"/docs/18/explicit-locking.html#LOCKING-ROWS\" title=\"13.3.2. Row-Level Locks\"\u003eSection 13.3.2\u003c/a\u003e. Two additional modes are specific to multixacts: \u003ccode class=\"literal\"\u003enokeyupd\u003c/code\u003e, used by updates that do not modify key columns, and \u003ccode class=\"literal\"\u003eupd\u003c/code\u003e, used by updates or deletes that modify key columns.","description_zh":"返回指定多事务 ID 中每个成员的事务 ID 和锁模式。锁模式 forupd、fornokeyupd、sh 和 keysh 分别对应于第 13.3.2 节中描述的行级锁 FOR UPDATE、FOR NO KEY UPDATE、FOR SHARE 和 FOR KEY SHARE。另有两种多事务特有的模式：nokeyupd 用于不修改键列的更新，upd 用于修改键列的更新或删除。","description_zh_html":"返回指定多事务 ID 中每个成员的事务 ID 和锁模式。锁模式 \u003ccode class=\"literal\"\u003eforupd\u003c/code\u003e、\u003ccode class=\"literal\"\u003efornokeyupd\u003c/code\u003e、\u003ccode class=\"literal\"\u003esh\u003c/code\u003e 和 \u003ccode class=\"literal\"\u003ekeysh\u003c/code\u003e 分别对应于\u003ca href=\"/docs/18/explicit-locking.html#LOCKING-ROWS\" title=\"13.3.2. 行级锁\"\u003e第 13.3.2 节\u003c/a\u003e中描述的行级锁 \u003ccode class=\"literal\"\u003eFOR UPDATE\u003c/code\u003e、\u003ccode class=\"literal\"\u003eFOR NO KEY UPDATE\u003c/code\u003e、\u003ccode class=\"literal\"\u003eFOR SHARE\u003c/code\u003e 和 \u003ccode class=\"literal\"\u003eFOR KEY SHARE\u003c/code\u003e。另有两种多事务特有的模式：\u003ccode class=\"literal\"\u003enokeyupd\u003c/code\u003e 用于不修改键列的更新，\u003ccode class=\"literal\"\u003eupd\u003c/code\u003e 用于修改键列的更新或删除。","examples":[],"html":"\u003ccode class=\"function\"\u003epg_get_multixact_members\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003emultixid\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003exid\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003esetof record\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003exid\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003exid\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003emode\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etext\u003c/code\u003e )","returns":"setof record","text":"pg_get_multixact_members ( multixid xid ) → setof record ( xid xid, mode text )","zh_from":"same-version-manual"}}],"Spellings":null,"SQLState":null,"Evidence":null}