Updated on 2023-10-23 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.

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, used to restore the texture file when the TRUNCATE object is restored.

rcycanrestore

bool

Whether flashback can be performed separately

rcycanpurge

bool

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.