U0000006:GaussDB does not support XXX as a column name of the table

Description

Database Type and Version

• Source database type and version: all types
• Target database type and version: GaussDB (M-compatible mode)

Syntax Example

On GaussDB databases, the following identifiers are system column names and cannot be used as column names in custom tables:

CTID, XMIN, CMIN, XMAX, CMAX, TABLEOID, XC_NODE_ID, TID, GS_TUPLE_UID, and TABLEBUCKETID

The following example is not supported in GaussDB:

CREATE TABLE ctid_test(ctid INT);

• During migration to GaussDB (M-compatible mode), if the preceding identifiers are used as column names in the table, these column names are not converted and this error is reported.
• During migration to other database types, if the preceding identifiers are used as column names in the table, double quotation marks are added and all letters are converted to uppercase by default. TID can be used as a custom column name in GaussDB Centralized V2.0-8.0 and later and in GaussDB Distributed V2.0-8.100 and later.

Suggestion

If the preceding system column names are used in the source database, you are advised to rename them according to object naming rules of GaussDB before migration. For details about object naming rules, see GaussDB Developer Guide.