48.10. lt_recyclebin

The catalog lt_recyclebin stores user dropped objects by command DROP TABLE.

Table 48.10. lt_recyclebin Columns

Column Type

Description

oid oid

object id of the dropped object

owner oid

Oid of the original owner of the object

object_name name

New name of the object

original_name name

Original name of the object

operation char

Operation carried out on the object

type int32

Type of the object, see definition of 'RELKIND_XXX' and 'OCLASS_XXX'

droptime timestamp with time zone

Timestamp for the dropping of the object

related oid

object number of the parent object

base_object oid

object number of the base object

purge_object oid

object number for the object which gets purged

objnamespace oid

namespace(schema) of this object

ts oid

Oid of the tablespace to which the object belongs

dropscn int8

unsed in LightDB

partition_name name

unsed in LightDB

can_undrop bool

unsed in LightDB

can_purge bool

unsed in LightDB

space int64

unsed in LightDB