GAUSS-00381 -- GAUSS-00390

GAUSS-00381: "misplaced INITIALLY DEFERRED clause"

SQLSTATE: 42601

Description: The syntax is incorrect.

Solution: Modify the SQL statement.

GAUSS-00382: "multiple INITIALLY IMMEDIATE/DEFERRED clauses not allowed"

SQLSTATE: 42601

Description: The syntax is incorrect.

Solution: Modify the SQL statement.

GAUSS-00383: "misplaced INITIALLY IMMEDIATE clause"

SQLSTATE: 42601

Description: The syntax is incorrect.

Solution: Modify the SQL statement.

GAUSS-00384: "CREATE specifies a schema (%s) different from the one being created (%s)"

SQLSTATE: 42P15

Description: In the CREATE SCHEMA schema_name schema_element... syntax, the schema name contained in the CREATE TABLE, CREATE VIEW, CREATE INDEX, CREATE PARTITION, or GRANT clause specified by schema_element does not match schema_name.

Solution: In the CREATE SCHEMA schema_name schema_element... syntax, ensure that the schema name contained in the CREATE TABLE, CREATE VIEW, CREATE INDEX, CREATE PARTITION, or GRANT clause specified by schema_element matches schema_name. "

GAUSS-00385: "unsupport inherits clause for partitioned table"

SQLSTATE: 42601

Description: The syntax is incorrect.

Solution: Modify the SQL statement.

GAUSS-00386: "inherited relation '%s' is a foreign table"

SQLSTATE: 42809

Description: The usage is not supported.

Solution: Modify the SQL statement.

GAUSS-00388: "ON COMMIT option is not supported for partitioned table"

SQLSTATE: 42601

Description: The CREATE TABLE table_name (...) ON COMMIT syntax does not support the partitioned table.

Solution: Use other syntax. For details, see "CREATE ROLE" in the SQL Syntax.

GAUSS-00389: "Typed table can not be partitioned"

SQLSTATE: 42601

Description: The CREATE ... TABLE OF type_name ... syntax cannot be used in this version currently.

Solution: Use other syntax.

GAUSS-00390: "unsupported feature with temporary/unlogged table for partitioned table"

SQLSTATE:42601

Description: The partitioned table in the CREATE TEMPORARY/UNLOGGED TABLE table_name ... syntax does not support the TEMPORARY or UNLOGGED attribute.

Solution: Ensure that the table of the TEMPORARY or UNLOGGED attribute specified in the CREATE TEMPORARY/UNLOGGED TABLE table_name ... syntax does not support the partitioned table. Change the table name to the name of a non-partitioned table.