Updated on 2024-05-07 GMT+08:00

GS_RECYCLEBIN

GS_RECYCLEBIN describes details about objects in the recycle bin.

Table 1 GS_RECYCLEBIN columns

Name

Type

Description

oid

oid

System column.

rcybaseid

oid

Base table object ID, which references gs_recyclebin.oid.

rcydbid

oid

OID of the database to which the current object belongs.

rcyrelid

oid

OID of the current object.

rcyname

name

Name of the object in the recycle bin. The format is BIN$unique_id$oid$0. unique_id indicates the unique identifier with a maximum of 16 characters, and oid indicates the OID.

rcyoriginname

name

Original object name.

rcyoperation

char

Operation type.

  • d: drop
  • t: truncate

rcytype

integer

Object type.

  • 0: table
  • 1: index
  • 2: TOAST table
  • 3: TOAST index
  • 4: sequence, indicating the sequence object that is automatically associated with the serial, bigserial, smallserial, and largeserial types.
  • 5: partition.
  • 6: global index.
  • 7: materialized view

rcyrecyclecsn

bigint

CSN when an object is dropped or truncated.

rcyrecycletime

timestamp with time zone

Time when an object is dropped or truncated.

rcycreatecsn

bigint

CSN when an object is created.

rcychangecsn

bigint

CSN when an object definition is modified.

rcynamespace

oid

OID of the namespace that contains this relationship

rcyowner

oid

Relationship owner

rcytablespace

oid

Tablespace where the relationship is stored. If the value is 0, the default tablespace of the database is used. This column is meaningless if the relationship has no on-disk file.

rcyrelfilenode

oid

File name of the recycle bin object on a disk, or 0 if none, which is used to restore the physical file when the TRUNCATE object is restored.

rcycanrestore

Boolean

Specifies whether flashback can be performed separately.

rcycanpurge

Boolean

Specifies whether the purge operation can be performed independently.

rcyfrozenxid

xid32

All transaction IDs before this one have been replaced with a permanent (frozen) transaction ID in the table.

rcyfrozenxid64

xid

All transaction IDs before this one have been replaced with a permanent (frozen) transaction ID in the table.