Updated on 2024-03-15 GMT+08:00

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-00387: "inherited relation '%s' is a partitioned table"

SQLSTATE: XX000

Description:"CREATE TABLE table_name (...) INHERITS ( parent_table [, ... In the syntax, parent_table is a partitioned table.

Solution: Check CREATE TABLE table_name (...) INHERITS (parent_table [, ... ]). Check whether parent_table in the syntax is a partitioned table. The syntax requires that the inherited parent_table cannot be a partitioned table."

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't 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.