{"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","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"],"signature":"pg_get_multixact_members ( multixid xid ) → setof record ( xid xid, mode text )","signature_count":1,"slug":"pg-get-multixact-members","source_rev":"b7bd9cda","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":"b7bd9cda","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":"","description_zh_html":"","doc":{"anchor":"FUNCTIONS-PG-SNAPSHOT","file":"functions-info.html","slug":"18"},"group":"info","group_label":"System Information Functions And Operators","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":"","description_zh_html":"","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":""}],"zh_from":""},"ManualEvidence":{"doc":{"anchor":"FUNCTIONS-PG-SNAPSHOT","file":"functions-info.html","slug":"18"}},"MeasuredEvidence":{}},"Text":{"Collection":"func","Key":"pg-get-multixact-members","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"pg_get_multixact_members","Summary":"返回指定多事务 ID 中每个成员的事务 ID 和锁模式。锁模式 forupd、fornokeyupd、sh 和 keysh 分别对应于第 13.3.2 节中描述的行级锁 FOR UPDATE、FOR NO KEY UPDATE、FOR SHARE 和 FOR KEY SHARE。另有两种多事务特有的模式：nokeyupd 用于不修改键列的更新，upd 用于修改键列的更新或删除。","BodyHTML":"返回指定多事务 ID 中每个成员的事务 ID 和锁模式。锁模式 \u003ccode\u003eforupd\u003c/code\u003e、\u003ccode\u003efornokeyupd\u003c/code\u003e、\u003ccode\u003esh\u003c/code\u003e 和 \u003ccode\u003ekeysh\u003c/code\u003e 分别对应于\u003ca href=\"/docs/18/explicit-locking.html#LOCKING-ROWS\" rel=\"nofollow\"\u003e第 13.3.2 节\u003c/a\u003e中描述的行级锁 \u003ccode\u003eFOR UPDATE\u003c/code\u003e、\u003ccode\u003eFOR NO KEY UPDATE\u003c/code\u003e、\u003ccode\u003eFOR SHARE\u003c/code\u003e 和 \u003ccode\u003eFOR KEY SHARE\u003c/code\u003e。另有两种多事务特有的模式：\u003ccode\u003enokeyupd\u003c/code\u003e 用于不修改键列的更新，\u003ccode\u003eupd\u003c/code\u003e 用于修改键列的更新或删除。\u003cpre\u003epg_get_multixact_members ( multixid xid ) → setof record ( xid xid, mode text )\u003c/pre\u003e返回指定多事务 ID 中每个成员的事务 ID 和锁模式。锁模式 \u003ccode\u003eforupd\u003c/code\u003e、\u003ccode\u003efornokeyupd\u003c/code\u003e、\u003ccode\u003esh\u003c/code\u003e 和 \u003ccode\u003ekeysh\u003c/code\u003e 分别对应于\u003ca href=\"/docs/18/explicit-locking.html#LOCKING-ROWS\" rel=\"nofollow\"\u003e第 13.3.2 节\u003c/a\u003e中描述的行级锁 \u003ccode\u003eFOR UPDATE\u003c/code\u003e、\u003ccode\u003eFOR NO KEY UPDATE\u003c/code\u003e、\u003ccode\u003eFOR SHARE\u003c/code\u003e 和 \u003ccode\u003eFOR KEY SHARE\u003c/code\u003e。另有两种多事务特有的模式：\u003ccode\u003enokeyupd\u003c/code\u003e 用于不修改键列的更新，\u003ccode\u003eupd\u003c/code\u003e 用于修改键列的更新或删除。","SourceRevision":"ca936764","ContentHash":"5a26ab6080d9d69cabdd437fadf158575b60dfbc666a11e4865cb5cedc05d821","Payload":{"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 用于修改键列的更新或删除。","signatures":[{"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 用于修改键列的更新或删除。","returns":"setof record","text":"pg_get_multixact_members ( multixid xid ) → setof record ( xid xid, mode text )","zh_from":"doc"}],"zh_from":"doc"}},"RequestedLocale":"zh-Hans","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":"","description_zh_html":"","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":""}}],"Spellings":null,"SQLState":null,"Evidence":null}