txid_snapshot_xip()

A function returning a snapshot's in-progress transaction IDs
This entry relates to a PostgreSQL feature which is deprecated and may be desupported in future releases.

txid_snapshot_xip() is a system function returning the set of in-progress transaction IDs contained in a snapshot.

txid_snapshot_xip() was added in PostgreSQL 8.3.

Usage

txid_snapshot_xip ( txid_snapshot ) → setof bigint

This function is deprecated following the introduction of the xid8 data type in PostgreSQL 13 and is superseded by pg_snapshot_xip().

Change history

Examples

Basic usage example for txid_snapshot_xip():

postgres=# SELECT * FROM txid_snapshot_xip(txid_current_snapshot());
 txid_snapshot_xip 
-------------------
               764
               769
(2 rows)

Categories

Deprecated, System function, Transactions

See also

pg_snapshot_xip(), txid_snapshot_xmin(), txid_snapshot_xmax(), txid_current_snapshot()