MogDB
Ecological Tools
Doc Menu

GAUSS-00701 – GAUSS-00800


GAUSS-00701 – GAUSS-00710


GAUSS-00701: "cannot rename inherited constraint '%s'"

SQLSTATE: 42P16

Description: The name of an inherited constraint is modified.

Solution: Do not modify the name of an inherited constraint.

GAUSS-00702: "relation '%s' already exists"

SQLSTATE: 42P07

Description: The relation already exists.

Solution: Ensure that the relation name is unique.

GAUSS-00703: "GTM error, could not rename sequence"

SQLSTATE: 08006

Description: GTM fails to rename a sequence.

Solution: Use gs_om -t status –detail to check whether the GTM status is normal.

GAUSS-00706: "partition '%s' of relation '%s' already exists"

SQLSTATE: 42P07

Description: A table partition of the same name already exists.

Solution: Ensure that the table partition name is unique.

GAUSS-00710: "cache lookup failed for partition %u of relation %u"

SQLSTATE: 42704

Description: Failed to find the partition.

Solution: The system is abnormal. Contact technical support.


GAUSS-00711 – GAUSS-00720


GAUSS-00711: "cannot %s '%s' because it is being used by active queries in this session"

SQLSTATE: 55006

Description: The object to be modified is being used.

Solution: Modify the object after the active queries are complete.

GAUSS-00712: "cannot %s '%s' because it has pending trigger events"

SQLSTATE: 55006

Description: Pending trigger events are detected when a table is modified.

Solution: Modify the table after pending trigger events are handled.

GAUSS-00713: "Un-support feature"

SQLSTATE: 0A000

Description: Feature not supported.

Solution: Do not use it.

GAUSS-00714: "unrecognized alter table type: %d"

SQLSTATE: XX000

Description: The table is changed to an unsupported type.

Solution: Check whether the new table type is supported.

GAUSS-00715: "Incompatible operation with data redistribution"

SQLSTATE: 54001

Description: The ALTER statement is incompatible with data redistribution.

Solution: Use the ALTER statement that is compatible with data redistribution.

GAUSS-00716: "cannot set with oids on partitioned table"

SQLSTATE: 0A000

Description: The attribute OIDs of partitioned tables are modified.

Solution: Do not modify the attribute OIDs of partitioned tables.

GAUSS-00717: "cannot set without oids on partitioned table"

SQLSTATE: 0A000

Description: The attribute OIDs of partitioned tables are modified.

Solution: Do not modify the attribute OIDs of partitioned tables.

GAUSS-00718: "cannot rewrite temporary tables of other sessions"

SQLSTATE: 0A000

Description: Temporary tables of other sessions are rewritten.

Solution: Do not rewrite temporary tables of other sessions.

GAUSS-00719: "cannot rewrite system relation '%s'"

SQLSTATE: 0A000

Description: The system catalog is rewritten.

Solution: Do not rewrite the system catalog.


GAUSS-00721 – GAUSS-00730


GAUSS-00721: "column '%s' contains null values"

SQLSTATE: 23502

Description: Non-null columns contain null values.

Solution: Check for conflicts in not-null constraints.

GAUSS-00722: "check constraint '%s' is violated by some row"

SQLSTATE: 23514

Description: Some rows violate check constraints.

Solution: Check for conflicts in check constraints.

GAUSS-00723: "cannot alter type '%s' because column '%s.%s' uses it"

SQLSTATE: 0A000

Description: The column type cannot be modified, because other columns depend on this column.

Solution: Check whether other columns depend on it. If they do, delete them and then modify the column type.

GAUSS-00724: "cannot alter foreign table '%s' because column '%s.%s' uses its row type"

SQLSTATE: 0A000

Description: A foreign table cannot be modified if its row type is being used by a column.

Solution: Check whether other columns depend on it. If they do, delete them and then modify the table.

GAUSS-00725: "cannot alter table '%s' because column '%s.%s' uses its row type"

SQLSTATE: 0A000

Description: A table cannot be modified if its row type is being used by a column.

Solution: Check whether other columns depend on it. If they do, delete them and then modify the table.

GAUSS-00726: "cannot alter type '%s' because it is the type of a typed table"

SQLSTATE: 2BP01

Description: The type of a typed table cannot be modified.

Solution: Use ALTER … CASCADE to modify the typed table.

GAUSS-00727: "type %s is not a composite type"

SQLSTATE: 42809

Description: The type of CREATE TABLE OFALTER TABLE OF is not a composite one.

Solution: Use a composite type and try again.

GAUSS-00728: "cannot add column to typed table"

SQLSTATE: 42809

Description: Columns are added to a typed table.

Solution: Do not add columns to a typed table.

GAUSS-00729: "type '%s' is not supported in column store"

SQLSTATE: 0A000

Description: Column storage does not support this column type.

Solution: Choose the correct column type and try again.

GAUSS-00730: "default value cannot reference to a column"

SQLSTATE: 42809

Description: A default value cannot be used in a column.

Solution: Check whether the default value is enclosed by a pair of quotation marks.


GAUSS-00731 – GAUSS-00740


GAUSS-00731: "child table '%s' has different type for column '%s'"

SQLSTATE: 42804

Description: When AddColumn is run to add a column to a parent table, this column and a column in the child tables share the same name but have different types.

Solution: Modify the type of the column to be added to that of the child tables.

GAUSS-00732: "child table '%s' has different collation for column '%s'"

SQLSTATE: 42P21

Description: When AddColumn is run to add a column to a parent table, this column and a column in the child tables share the same name but have different collations.

Solution: Modify the collation of the column to be added to that of the child tables.

GAUSS-00733: "child table '%s' has a conflicting '%s' column"

SQLSTATE: 42804

Description: When AddColumn is run to add a column to a parent table, the column already exists in the child tables.

Solution: Rename the column to be added.

GAUSS-00735: "column must be added to child tables too"

SQLSTATE: 42P16

Description: When AddColumn is run to add a column to a parent table, the column is not added to the child tables.

Solution: Add the column recursively to the child tables.

GAUSS-00736: "column '%s' of relation '%s' already exists"

SQLSTATE: 42701

Description: When a column is added to a relational table or a column name is changed, the column name already exists.

Solution: Specify the column name again.

GAUSS-00737: "cannot alter system column '%s'"

SQLSTATE: 0A000

Description: When ALTER TABLE ALTER COLUMN DROP is run, the column of a system catalog cannot be modified.

Solution: Cancel this operation.

GAUSS-00738: "column '%s' is in a primary key"

SQLSTATE: 42P16

Description: When ALTER TABLE ALTER COLUMN DROP is run, the primary key of a table cannot be modified.

Solution: Cancel this operation.

GAUSS-00739: "'%s' is not a table, index, or foreign table"

SQLSTATE: 42809

Description: When ALTER TABLE ALTER COLUMN SET STATISTICS is run, the object to be modified is not a common table, index, or foreign table.

Solution: Run this statement when the object is a common table, index, or foreign table, or cancel this operation.

GAUSS-00740: "statistics target %d is too low"

SQLSTATE: 22023

Description: When ALTER TABLE ALTER COLUMN SET STATISTICS is run, the value of a statistics target is excessively small.

Solution: Set a valid value for the statistics target.


GAUSS-00741 – GAUSS-00750


GAUSS-00741: "invalid storage type '%s'"

SQLSTATE: 22023

Description: When ALTER TABLE ALTER COLUMN SET STORAGE is run, the target data storage type is invalid.

Solution: Modify the target data storage type to a valid one.

GAUSS-00742: "column data type %s can only have storage PLAIN"

SQLSTATE: 0A000

Description: When ALTER TABLE ALTER COLUMN SET STORAGE is run, the column data storage type is not set to PLAIN.

Solution: Set the column data storage type to PLAIN.

GAUSS-00743: "cannot drop column from typed table"

SQLSTATE: 42809

Description: When ALTER TABLE DROP COLUMN is run, the column of a typed table cannot be deleted.

Solution: Cancel this operation.

GAUSS-00745: "cannot drop system column '%s'"

SQLSTATE: 0A000

Description: When ALTER TABLE DROP COLUMN is run, the column of a system catalog cannot be deleted.

Solution: Cancel this operation.

GAUSS-00747: "cache lookup failed for attribute '%s' of relation %u"

SQLSTATE: XX000

Description: Failed to find the column.

Solution: The system is abnormal. Contact technical support.

GAUSS-00748: "relation %u has non-inherited attribute '%s'"

SQLSTATE: XX000

Description: The inherited table does not have the corresponding inherited columns.

Solution: The system is abnormal. Contact technical support.

GAUSS-00749: "index '%s' is not unique"

SQLSTATE: XX000

Description: The index related to the added unique constraint does not have the unique attribute.

Solution: The system is abnormal. Contact technical support.

GAUSS-00750: "constraint '%s' for relation '%s' already exists"

SQLSTATE: 42710

Description:ALTER TABLE ADD CONSTRAINT cannot be run if new constraints already exist.

Solution: Modify the new constraints.


GAUSS-00751 – GAUSS-00760


GAUSS-00751: "cluster key for relation '%s' already exists"

SQLSTATE: 42710

Description:ALTER TABLE ADD CONSTRAINT cannot be run if the cluster key of a relational table already exists.

Solution: Modify the new constraints.

GAUSS-00753: "referenced relation '%s' is not a table"

SQLSTATE: 42809

Description: When foreign key constraints are added to a table, the referenced table of foreign key constraints is not an ordinary table.

Solution: Ensure that the referenced table of foreign key constraints is an ordinary table.

GAUSS-00754: "Invalid FOREIGN KEY constraints"

SQLSTATE: 42809

Description: The referenced table of foreign key constraints is a partitioned table although the partitioned table supports creating foreign key constraints.

Solution: Ensure that the referenced table of foreign key constraints is an ordinary table.

GAUSS-00755: "constraints on permanent tables may reference only permanent tables"

SQLSTATE: 42P16

Description: Foreign key constraints on ordinary tables do not reference ordinary tables.

Solution: Modify the referenced tables of foreign key constraints to ordinary tables.

GAUSS-00756: "constraints on unlogged tables may reference only permanent or unlogged tables"

SQLSTATE: 42P16

Description: Foreign key constraints on unlogged tables do not reference ordinary tables or unlogged tables.

Solution: Modify the referenced tables of the foreign key constraints to ordinary tables or unlogged tables.

GAUSS-00757: "constraints on temporary tables may reference only temporary tables"

SQLSTATE: 42P16

Description: Foreign key constraints on temporary tables do not reference temporary tables.

Solution: Modify the referenced tables of the foreign key restraints to temporary tables, or cancel this operation.

GAUSS-00758: "constraints on temporary tables must involve temporary tables of this session"

SQLSTATE: 42P16

Description: Foreign key constraints on temporary tables do not reference local temporary tables.

Solution: Modify the referenced tables of the foreign key restraints to temporary tables, or cancel this operation.

GAUSS-00759: "number of referencing and referenced columns for foreign key disagree"

SQLSTATE: 42830

Description: When foreign key constraints are added to a table, the number of constrained columns differs from that of quoted columns.

Solution: Modify the foreign key constraints to ensure that the number of constrained columns is the same as that of quoted columns.

GAUSS-00760: "only b-tree indexes are supported for foreign keys"

SQLSTATE: XX000

Description: The index of the primary key corresponding to the foreign key is not a B-tree index.

Solution: Ensure that the unique constraint index of the primary key is a B-tree index.


GAUSS-00761 – GAUSS-00770


GAUSS-00761: "missing operator %d(%u,%u) in opfamily %u"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-00762: "foreign key constraint '%s' cannot be implemented"

SQLSTATE: 42804

Description: When foreign key constraints are added to a table, the type of constrained columns differs from that of quoted columns.

Solution: Modify the foreign key constraints to ensure that the type of constrained columns is the same as that of quoted columns.

GAUSS-00763: "Cannot create foreign key whose evaluation cannot be enforced to remote nodes"

SQLSTATE: 0A000

Description: When foreign key constraints are added to a table, the foreign key constraints on referencing remote nodes cannot be created.

Solution: Cancel this operation.

GAUSS-00764: "constraint '%s' of relation '%s' does not exist"

SQLSTATE: 42704

Description: When ALTER TABLE VALIDATE CONSTRAINT is run, the constraint on a table does not exist.

Solution: Modify the constraints that already exist, or cancel this operation.

GAUSS-00765: "constraint '%s' of relation '%s' is not a foreign key or check constraint"

SQLSTATE: 42809

Description: When ALTER TABLE VALIDATE CONSTRAINT is run, the relationship constraints are not foreign key constraints or check constraints.

Solution: Modify or cancel this operation.

GAUSS-00766: "constraint must be validated on child tables too"

SQLSTATE: 42P16

Description: When ALTER TABLE VALIDATE CONSTRAINT is run to add a constraint to a parent table, the constraint is not added to the child tables.

Solution: Add the constraint to the child tables.

GAUSS-00767: "column '%s' referenced in foreign key constraint does not exist"

SQLSTATE: 42703

Description: The referenced column of foreign key constraints on a relational table does not exist.

Solution: Modify the foreign key constraints.

GAUSS-00768: "cannot have more than %d keys in a foreign key"

SQLSTATE: 54011

Description: The number of referenced columns for a foreign key is greater than 32.

Solution: Limit the number of referenced columns for a foreign key.

GAUSS-00769: "cannot use a deferrable primary key for referenced table '%s'"

SQLSTATE: 55000

Description:GetPrimaryKey cannot be run for a deferrable primary key.

Solution: Cancel this operation.

GAUSS-00770: "there is no primary key for referenced table '%s'"

SQLSTATE: 42704

Description: When GetPrimaryKey is run, the referenced table has no primary key.

Solution: Cancel this operation.


GAUSS-00771 – GAUSS-00780


GAUSS-00771: "cannot use a deferrable unique constraint for referenced table '%s'"

SQLSTATE: 55000

Description: Foreign keys depend on a deferrable unique constraint.

Solution: Modify the dependency of foreign keys.

GAUSS-00772: "there is no unique constraint matching given keys for referenced table '%s'"

SQLSTATE: 42830

Description: Keys of the table that foreign keys depend on are not unique.

Solution: Modify dependency of foreign keys.

GAUSS-00773: "could not find cast from %u to %u"

SQLSTATE: XX000

Description: The conversion method between the types cannot be found.

Solution: Verify that no type conversion method is available in the pg_cast system catalog. Contact technical support.

GAUSS-00774: "null conbin for constraint %u"

SQLSTATE: XX000

Description: The constraint attribute is null.

Solution: The system catalog is abnormal. Contact technical support.

GAUSS-00775: "unrecognized FK action type: %d"

SQLSTATE: XX000

Description: The foreign key trigger type does not exist.

Solution: Check the type of the foreign key trigger.

GAUSS-00776: "cannot drop inherited constraint '%s' of relation '%s'"

SQLSTATE: 42P16

Description: When ALTER TABLE DROP CONSTRAINT is run, inherited constraints cannot be deleted.

Solution: Modify this operation.

GAUSS-00777: "relation %u has non-inherited constraint '%s'"

SQLSTATE: XX000

Description: The inherited table does not have the corresponding inherited constraints.

Solution: The system catalog is abnormal. Contact technical support.

GAUSS-00778: "cannot alter column type of typed table"

SQLSTATE: 42809

Description: When ALTER COLUMN TYPE is run, the column type of a typed table cannot be modified.

Solution: Modify this operation.

GAUSS-00779: "cannot alter inherited column '%s'"

SQLSTATE: 42P16

Description: When ALTER COLUMN TYPE is run, the column type of an inherited table cannot be modified.

Solution: Modify this operation.

GAUSS-00780: "cache lookup failed for pgxc_class %u"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.


GAUSS-00781 – GAUSS-00790


GAUSS-00781: "cannot alter data type of distribute column"

SQLSTATE: 0A000

Description: When ALTER COLUMN TYPE is run, the distribution column type of a table cannot be modified.

Solution: Modify this operation.

GAUSS-00784: "cannot use subquery in transform expression"

SQLSTATE: 0A000

Description: When ALTER COLUMN TYPE is run, a transform expression uses a subquery.

Solution: Modify this operation.

GAUSS-00785: "cannot use aggregate function in transform expression"

SQLSTATE: 42803

Description: When ALTER COLUMN TYPE is run, a transform expression uses an aggregate function.

Solution: Modify this operation.

GAUSS-00786: "cannot use window function in transform expression"

SQLSTATE: 42P20

Description: When ALTER COLUMN TYPE is run, a transform expression uses a window function.

Solution: Modify this operation.

GAUSS-00788: "type of inherited column '%s' must be changed in child tables too"

SQLSTATE: 42P16

Description: When ALTER COLUMN TYPE is run, the column type of a child table does not change as the column type of its parent table changes.

Solution: In the statement, specify that the child table changes when the parent table changes.

GAUSS-00789: "cannot alter data type of partitioning column '%s'"

SQLSTATE: 0A000

Description: When ALTER COLUMN TYPE is run, the column type of a partitioned table cannot be modified.

Solution: Modify this operation.

GAUSS-00790: "cannot alter type of column '%s' twice"

SQLSTATE: 0A000

Description: When ALTER COLUMN TYPE is run, the type of a column cannot be modified twice.

Solution: Modify a column type only once.


GAUSS-00791 – GAUSS-00800


GAUSS-00791: "default for column '%s' cannot be cast automatically to type %s"

SQLSTATE: 42804

Description: When ALTER COLUMN TYPE is run, a default expression cannot be automatically cast to a type.

Solution: Modify this operation.

GAUSS-00792: "cannot alter type of a pinned column"

SQLSTATE: XX000

Description: The type of the column cannot be changed, because other objects depend on it.

Solution: Find and delete the dependency, and then change the column type.

GAUSS-00793: "unexpected object depending on column: %s"

SQLSTATE: XX000

Description: The dependency type does not exist.

Solution: The system catalog is abnormal. Contact technical support.

GAUSS-00794: "cannot alter type of a column used by a view or rule"

SQLSTATE: 0A000

Description: When ALTER COLUMN TYPE is run, a view or rule is used to change the type of a column.

Solution: Modify this operation.

GAUSS-00795: "cannot alter type of a column used in a trigger definition"

SQLSTATE: 0A000

Description: When ALTER COLUMN TYPE is run, the type of a column used in a trigger definition cannot be modified.

Solution: Modify this operation.

GAUSS-00796: "unrecognized object class: %u"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-00797: "found unexpected dependency type '%c'"

SQLSTATE: XX000

Description: The dependency type is incorrect.

Solution: The system catalog is abnormal. Contact technical support.

GAUSS-00798: "found unexpected dependency for column"

SQLSTATE: XX000

Description: The column dependency type is incorrect.

Solution: The system catalog is abnormal. Contact technical support.

GAUSS-00799: "foreign table '%s' does not exist"

SQLSTATE: 42704

Description: When ALTER COLUMN OPTIONS is run, a foreign table does not exist.

Solution: Modify this operation.

GAUSS-00800: "unexpected statement type: %d"

SQLSTATE: XX000

Description: The clause to change a statement is incorrect.

Solution: Check whether the clause is supported.