Updated on 2025-05-29 GMT+08:00

GS_LOGICAL_SET

GS_LOGICAL_SET records metadata defined by the SET data type.

Table 1 GS_LOGICAL_SET columns

Column

Type

Description

setid

oid

Row identifier.

settypid

oid

OID of the SET data type

setnum

tinyint

Number of members of the SET data type. A maximum of 64 members are supported.

setsortorder

tinyint

Sorting order of members when the SET data type is defined. The value starts from 0.

setlabel

text

Member name of the SET data type.

dbnode

oid

Database OID.

originid

integer

Source identifier of a tuple.

createtime

timestamp with time zone

Timestamp when a tuple is inserted.

csnmin

bigint

CSN when a tuple is inserted.

csnmax

bigint

CSN when a tuple is updated or deleted.

numbers

integer

Number of members of the M-compatible SET and ENUM data types. This column is used only in M-compatible databases.

sortorder

integer

Sorting order of members when the M-compatible SET and ENUM data types are defined. This column is used only in M-compatible databases.