Object Identifier Type

DataArts Fabric SQL internally uses object identifiers (OIDs) as primary keys for various system catalogs. The system does not add an OID system column to the table created by the user. The OID type indicates an object identifier.

Currently, the OID type is implemented as an unsigned four-byte integer. Therefore, you are advised not to use the OID column as the primary key in the created table.

**Table 1** Object identifier types
Type	Reference	Description	Example
OID	-	Digital object identifier.	564182
CID	-	Command identifier. It is the data type of the system columns cmin and cmax. The command identifier is a 32-bit quantity.	-
XID	-	Transaction identifier. It is the data type of the system columns xmin and xmax. The transaction identifier is a 32-bit quantity.	-
TID	-	Row identifier. It is the data type of the system column ctid. A row ID is a pair of values (block number, row index within the block) that identifies the physical location of a row in its table.	-
REGCONFIG	pg_ts_config	Text search configuration.	english
REGDICTIONARY	pg_ts_dict	Text search dictionary.	simple
REGOPER	pg_operator	Operator name.	+
REGOPERATOR	pg_operator	Operator with parameter types.	*(integer,integer) or -(NONE,integer)
REGPROC	pg_proc	Function name.	sum
REGPROCEDURE	pg_proc	Function with parameter types.	sum(int4)
REGCLASS	pg_class	Relation name.	pg_type
REGTYPE	pg_type	Data type name.	integer

OID type: Used as a field in the database system catalog.

Example:

   
        postgres=#SELECT oid FROM pg_class WHERE relname = 'pg_type';
 oid  
------
 1247
(1 row)

OID alias type REGCLASS: Mainly used for simplified lookup of object OID values.

Example:

   
    
      
      
        postgres=#SELECT attrelid,attname,atttypid,attstattarget FROM pg_attribute WHERE attrelid = 'pg_type'::REGCLASS;
 attrelid |    attname     | atttypid | attstattarget
----------+----------------+----------+---------------
| xc_node_id     |       23 |             0
| tableoid       |       26 |             0
| cmax           |       29 |             0
| xmax           |       28 |             0
| cmin           |       29 |             0
| xmin           |       28 |             0
| oid            |       26 |             0
| ctid           |       27 |             0
| typname        |       19 |            -1
| typnamespace   |       26 |            -1
| typowner       |       26 |            -1
| typlen         |       21 |            -1
| typbyval       |       16 |            -1
| typtype        |       18 |            -1
| typcategory    |       18 |            -1
| typispreferred |       16 |            -1
| typisdefined   |       16 |            -1
| typdelim       |       18 |            -1
| typrelid       |       26 |            -1
| typelem        |       26 |            -1
| typarray       |       26 |            -1
| typinput       |       24 |            -1
| typoutput      |       24 |            -1
| typreceive     |       24 |            -1
| typsend        |       24 |            -1
| typmodin       |       24 |            -1
| typmodout      |       24 |            -1
| typanalyze     |       24 |            -1
| typalign       |       18 |            -1
| typstorage     |       18 |            -1
| typnotnull     |       16 |            -1
| typbasetype    |       26 |            -1
| typtypmod      |       23 |            -1
| typndims       |       23 |            -1
| typcollation   |       26 |            -1
| typdefaultbin  |      194 |            -1
| typdefault     |       25 |            -1
| typacl         |     1034 |            -1
(38 rows)

       

     

   
  