27.2. pga_snapshot_changes Metadata Table
Prev UpChapter 27. Metadata TablesHome Next

27.2. pga_snapshot_changes Metadata Table #

This metadata table contains information about snapshot changes. You can use it to resolve conflicts between different snapshots.

Column Name

Column Type

Constraint

Description

snapshot_id

BIGINT

Primary key, foreign key

The ID of the snapshot from the pga_snapshot metadata table.

changes_made

VARCHAR

-

A comma-separated list of snapshot changes in the following formats:

  • created_schema:schema_name: The snapshot is associated with creating an analytical schema.

  • created_table:table_name: The snapshot is associated with creating an analytical table.

  • created_view:view_name: The snapshot is associated with creating a Postgres Pro view.

  • inserted_into_table:table_ID: The snapshot is associated with adding the OLAP data to an analytical table.

  • deleted_from_table:table_ID: The snapshot is associated with deleting the OLAP data from an analytical table.

  • dropped_schema:schema_ID: The snapshot is associated with deleting an analytical schema.

  • dropped_table:table_ID: The snapshot is associated with deleting an analytical table.

  • dropped_view:view_ID: The snapshot is associated with deleting a Postgres Pro view.

  • altered_table:table_ID: The snapshot is associated with updating metadata of an analytical table.

  • altered_view:view_ID: The snapshot is associated with updating metadata of a Postgres Pro view.

Prev Up Next
27.1. pga_snapshot Metadata Table Home 27.3. pga_schema Metadata Table