GAUSS-00381 -- GAUSS-00390
GAUSS-00381: “misplaced INITIALLY DEFERRED clause”
SQLSTATE: 42601
Description: Syntax error.
Solution: Modify the SQL statement.
GAUSS-00382: “multiple INITIALLY IMMEDIATE/DEFERRED clauses not allowed”
SQLSTATE: 42601
Description: Syntax error.
Solution: Modify the SQL statement.
GAUSS-00383: “misplaced INITIALLY IMMEDIATE clause”
SQLSTATE: 42601
Description: Syntax error.
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: Syntax error.
Solution: Modify the SQL statement.
GAUSS-00386: “inherited relation '%s' is a foreign table”
SQLSTATE: 42809
Description: Usage not supported.
Solution: Modify the SQL statement.
GAUSS-00387: “inherited relation '%s' is a partitioned table”
SQLSTATE: XX000
Description: parent_table in the CREATE TABLE table_name (…) INHERITS (parent_table [, … ]) syntax is a partitioned table.
Solution: Ensure that the inherited parent_table required by the syntax is not a partitioned table.
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: Change the partitioned table to a non-partitioned table.