GAUSS-00051 -- GAUSS-00060

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

View PDF

GAUSS-00051: "improper %%TYPE reference (too many dotted names): %s"

SQLSTATE: 42601

Description: table_name.column_name%TYPE defined in the function is incorrect. Excessive parameters are specified on the left of .column_name.

Solution: Check whether the table name or column name referenced in table_name.column_name%TYPE defined in the function is correct. If it is incorrect, change the syntax and create the function again to define table_name.column_name%TYPE.

GAUSS-00052: "column '%s' of relation '%s' does not exist"

SQLSTATE: 42703

Description: The column name is empty, is incorrectly spelled, or is not a column name in the relational table.

Solution: Run the \d tblname command to check whether the specified column name is the one specified in the table. If it is not, change it to a valid column name.

GAUSS-00053: "type '%s' does not exist"

SQLSTATE: 42704

Description: A specified type is not found in the pg_type system catalog.

Solution: Correct the type used in the statement. (See types defined in the pg_type system catalog.)

GAUSS-00054: "type '%s' is only a shell"

SQLSTATE: 42704

Description: No corresponding operation execution functions are defined in the pg_type system catalog for the specified type.

Solution: Check whether the type used in the statement is correct. If it is, use the CREATE TYPE statement to define the operation function corresponding to the specified type.

GAUSS-00055: "type modifier cannot be specified for shell type '%s'"

SQLSTATE: 42601

Description: The user-defined type contains typmod.

Solution: Correct the user-defined type, typmod.

GAUSS-00056: "type modifier is not allowed for type '%s'"

SQLSTATE: 42601

Description: The user-defined type contains typmod.

Solution: Correct the user-defined type, typmod.

GAUSS-00057: "type modifiers must be simple constants or identifiers"

SQLSTATE: 42601

Description: The provided type modifier is incorrect.

Solution: A type modifier must be defined as a constant or identifier. Check whether the syntax of the specified type modifier is correct. If it is incorrect, define a valid type modifier.

GAUSS-00058: "collations are not supported by type %s"

SQLSTATE: 42804

Description: Invalid collation type.

Solution: Check the type in the statement. Collate only supports character types.

Example:

   
      postgres=# create table t1(a int collate "C");
ERROR:  collations are not supported by type integer
LINE 1: create table t1(a int collate "C");