Help Center/GaussDB/Developer Guide(Distributed_V2.0-3.x)/System Catalogs and System Views/System Catalogs/GS_RECYCLEBIN
Updated on 2025-08-19 GMT+08:00
View PDF

GS_RECYCLEBIN

GS_RECYCLEBIN describes details about objects in the recycle bin of the flashback feature.

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. The options are as follows:
  • d: drop
  • t: truncate

rcytype

integer

Object type. The options are as follows:
  • 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

SCN when an object definition is modified

rcynamespace

oid

OID of the namespace that contains this relationship

rcyowner

oid

Owner of the relationship

rcytablespace

oid

Tablespace in which this 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.

Parent topic:System Catalogs