GAUSS-04681 -- GAUSS-04690

GaussDB (DWS) does not support some PostgreSQL features. Therefore, an error message may be displayed during SQL execution, indicating that a feature is not supported. For details, see PostgreSQL Features Unsupported by GaussDB(DWS).

GAUSS-04681: "EXCLUDE constraint is not yet supported."

SQLSTATE: 0A000

Description: GaussDB (DWS) does not support using EXCLUDE to create exclusive constraints for tables.

Solution: Do not use this feature.

GAUSS-04682: "FOREIGN KEY ... REFERENCES constraint is not yet supported."

SQLSTATE: 0A000

Description: GaussDB (DWS) does not support creating FOREIGN KEY constraints for tables.

Solution: Do not use this feature.

GAUSS-04683: "CREATE TABLE ... INHERITS is not yet supported."

SQLSTATE: 0A000

Description: GaussDB (DWS) does not support INHERITS.

Solution: Do not use this feature.

GAUSS-04684: "CREATE TABLE ... WITH OIDS is not yet supported."

SQLSTATE: 0A000

Description: GaussDB (DWS) Does Not Support CREATE TABLE... WITH OIDS.

Solution: Do not use this feature.

GAUSS-04685: "Unrecognized distribution option '%s'."

SQLSTATE: 42601

Description: The distribution key option cannot be recognized.

Solution:contact technical support

GAUSS-04686: "Syntax is not supported"

SQLSTATE: 42601

Description: The syntax cannot be recognized.

Solution: Do not use this feature. For details about the supported syntax, see "CREATE TABLE" in the SQL Syntax.

GAUSS-04687: "SCROLL CURSOR is not yet supported."

SQLSTATE: 0A000

Description: GaussDB (DWS) does not support SCROLL CURSOR.

Solution: Do not use this feature.

GAUSS-04688: "INSENSITIVE CURSOR is not yet supported."

SQLSTATE: 0A000

Description: GaussDB (DWS) does not support INSENSITIVE CURSOR.

Solution: Do not use this feature.

GAUSS-04689: "CURSOR ... WITH HOLD is not yet supported."

Description: An internal system error occurs.

Solution:contact technical support

GAUSS-04690: "For foreign table ROUNDROBIN distribution type is built-in support."

SQLSTATE: 0A000

Description: By default, a GDS foreign table is created in ROUNDROBIN distribution mode. You cannot explicitly add ROUNDROBIN distribution information when creating a foreign table.

Solution: When creating a GDS foreign table, remove the specified distribution information, that is, remove DISTRIBUTE BY ROUNDROBIN from the statement.