Postgres Pro AXE : Documentation: 1: 38.17. pga_transaction_log : Postgres Professional

38.17. `pga_transaction_log`
Prev	Up	Chapter 38. Metadata Tables	Home	Next

38.17. `pga_transaction_log` #

This metadata table contains logging information about pgpro_metastore tasks analogous to standard DBMS transactions.

Column Name	Column Type	Constraint	Description
`lsn`	`BIGSERIAL`	Primary key	The transaction log sequence number (LSN).
`txid`	`BIGINT`	`NOT NULL`	The task ID.
`op_id`	`INT`	-	The stored procedure ID. One task can consist of multiple stored procedures.
`kind`	`VARCHAR`	`NOT NULL`	The stored procedure type. Possible values: `metastore.define_catalog_connection` `metastore.init` `metastore.cleanup` `metastore.add_storage` `metastore.remove_storage` `metastore.add_table` `metastore.rename_table` `metastore.create_view` `metastore.remove_table` `metastore.add_column` `metastore.rename_column` `metastore.change_column_type` `metastore.delete_column` `metastore.add_schema` `metastore.remove_schema` `metastore.add_folder` `metastore.remove_folder` `metastore.add_files` `metastore.copy_table` `metastore.expire_snapshot_on_time` `metastore.expire_snapshot_on_ids` `metastore.delete_expired_files` `metastore.mgrant` `metastore.mrevoke` `metastore.pgpro_build`
`attr`	`JSONB`	-	The initial and runtime data associated with the task.

Prev	Up	Next
38.16. `pga_partition_value`	Home	38.18. `pga_proxy_table`

epub pdf