Help Center/ GaussDB(DWS)/ Error Code Reference/ Data Warehouse Service Error Codes/ GAUSS-00301 -- GAUSS-00400/ GAUSS-00371 -- GAUSS-00380
Updated on 2024-03-15 GMT+08:00
View PDF

GAUSS-00371 -- GAUSS-00380

GAUSS-00371: "ON SELECT rule cannot use OLD"

SQLSTATE: 42P17

Description: The name of the referenced table in the WHERE condition expression of the CREATE RULE name AS ON SELECT syntax is OLD.

Solution: Check whether the name of the referenced table in the WHERE condition expression of the CREATE RULE name AS ON SELECT syntax is OLD. If yes, change the referenced table name to non-OLD.

GAUSS-00372: "ON SELECT rule cannot use NEW"

SQLSTATE: 42P17

Description: The name of the referenced table in the WHERE condition expression of the CREATE RULE name AS ON SELECT syntax is NEW.

Solution: Check whether the name of the referenced table in the WHERE condition expression of the CREATE RULE name AS ON SELECT syntax is NEW. If yes, change the referenced table name to non-NEW.

GAUSS-00373: "ON INSERT rule cannot use OLD"

SQLSTATE: 42P17

Description: The name of the referenced table in the WHERE condition expression of the CREATE RULE name AS ON INSERT syntax is OLD.

Solution: Check whether the name of the referenced table in the WHERE condition expression of the CREATE RULE name AS ON INSERT syntax is OLD. If yes, change the referenced table name to non-OLD.

GAUSS-00374: "ON DELETE rule cannot use NEW"

SQLSTATE: 42P17

Description: The name of the referenced table in the WHERE condition expression of the CREATE RULE name AS ON DELETE syntax is NEW.

Solution: Check whether the name of the referenced table in the WHERE condition expression of the CREATE RULE name AS ON DELETE syntax is NEW. If yes, change the referenced table name to non-NEW.

GAUSS-00375: "cannot refer to OLD within WITH query"

SQLSTATE: 0A000

Description: If a WITH clause is contained in the CREATE RULE syntax, the WITH clause incorrectly uses the OLD table as reference.

Solution: Ensure that a WITH clause does not use the OLD table as reference if the WITH clause is contained in the CREATE RULE syntax. Modify the syntax of the WITH clause.

GAUSS-00376: "cannot refer to NEW within WITH query"

SQLSTATE: 0A000

Description: If a WITH clause is contained in the CREATE RULE syntax, the WITH clause incorrectly uses the NEW table as reference.

Solution: Ensure that a WITH clause does not reference the NEW table if the WITH clause is contained in the CREATE RULE syntax. Modify the syntax of the WITH clause.

GAUSS-00377: "missing definition of adding partition"

SQLSTATE: XX000

Description: When the ALTER TABLE ADD PARTITION syntax is used to add a partition to a specified partitioned table, invalid values exist in the partition columns, indexes, constraints, or parent tables defined in the partition.

Solution: Check whether invalid values exist in the partition columns, indexes, constraints, or parent tables defined in the partition when the ALTER TABLE ADD PARTITION syntax is used to add a partition to a specified partitioned table.

GAUSS-00378: "misplaced DEFERRABLE clause"

SQLSTATE: 42601

Description: The constraint types of columns specified by the column_constraint clause in the CREATE TABLE or ALTER TABLE syntax are incorrectly deferrable types.

Solution: Ensure that the constraint types of columns specified by the column_constraint clause in the CREATE TABLE or ALTER TABLE syntax can be deferrable only after its type is primary key, UNIQUE, exclusion, or foreign table.

GAUSS-00379: "multiple DEFERRABLE/NOT DEFERRABLE clauses not allowed"

SQLSTATE: 42601

Description: Deferrable types and non-deferrable types exist in the lists of the column_constraint clause in the CREATE TABLE or ALTER TABLE syntax.

Solution: Ensure that either deferrable types or non-deferrable types exist in the lists of the column_constraint clause in the CREATE TABLE or ALTER TABLE syntax. Modify the lists of the column_constraint clause.

GAUSS-00380: "misplaced NOT DEFERRABLE clause"

SQLSTATE: 42601

Description: The constraint types of columns specified by the column_constraint clause in the CREATE TABLE or ALTER TABLE syntax are non-deferrable types.

Solution: Ensure that the constraint types of columns specified by the column_constraint clause in the CREATE TABLE or ALTER TABLE syntax can be deferrable only after its type is primary key, UNIQUE, exclusion, or foreign table.