MogDB
Ecological Tools
Doc Menu

GAUSS-00001 – GAUSS-00100


GAUSS-00001 – GAUSS-00010


GAUSS-00001: "operator does not exist: %s"

SQLSTATE: 42883

Description: The specified operator does not exist.

Solution: Ensure that the error code contains the data type corresponding to the operator so that you can check whether the operator exists in the system catalog.

GAUSS-00002: "could not identify an ordering operator for type %s"

SQLSTATE: 42883

Description: When you perform a sort or group operation, data is sorted. If the greater than (gt) or less than (lt) operator corresponding to the data type does not exist, this error is reported.

Solution: The error code contains a data type. Query the operator corresponding to the data type from the pg_operator system catalog before using the operator and ensure that the operator exists.

GAUSS-00003: "could not identify an equality operator for type %s"

SQLSTATE: 42883

Description: When you perform a group or unique operation, if the equal to (et) operation is involved, but the operator corresponding to the involved data type does not exist, this error is reported.

Solution: The error code contains a data type. Query the operator corresponding to the data type from the pg_operator system catalog before using the operator and ensure that the operator exists.

GAUSS-00004: "operator requires run-time type coercion: %s"

SQLSTATE: 42883

Description:order by using is used to specify an operator. During code execution, a parse function checks whether the provided data type and operator match. If they do not match, this error is reported.

Solution: Ensure that the specified operator and data type match.

GAUSS-00005: "operator is not unique: %s"

SQLSTATE: 42725

Description: No identified operators are provided for certain data types. Data types need to be converted to match proper operators. When multiple data types are converted, this error is reported.

Solution: Convert a data type that has no corresponding operator to use a specific operator.

GAUSS-00006: "operator is only a shell: %s"

SQLSTATE: 42883

Description: Undefined function.

Solution: Modify the input statement.

GAUSS-00007: "op ANY/ALL (array) requires array on right side"

SQLSTATE: 42809

Description: For the ANY/ALL (array) operator, the right parameter is not of the array type.

Solution: For the ANY/ALL (array) operator, use the right parameter of the array type.

GAUSS-00008: "op ANY/ALL (array) requires operator to yield Boolean"

SQLSTATE: 42809

Description: The value returned for the ANY/ALL (array) operator is not of the Boolean type.

Solution: Ensure that the value returned for the ANY/ALL (array) operator is of the Boolean type.

GAUSS-00009: "op ANY/ALL (array) requires operator not to return a set"

SQLSTATE: 42809

Description: The value returned for the ANY/ALL (array) operator is of the set type, which is not supported.

Solution: Ensure that the value returned for the ANY/ALL (array) operator is of a type excluding the set type.

GAUSS-00010: "could not find array type for data type %s"

SQLSTATE: 42704

Description: The array type corresponding to a data type cannot be found.

Solution: When using the array type corresponding to a data type, ensure that any corresponding or compatible array type exists in the pg_type system catalog.


GAUSS-00011 – GAUSS-00020


GAUSS-00011: "hash table corrupted"

SQLSTATE: LL002

Description: The hash table is damaged.

Solution:Contact technical support.

GAUSS-00012: "target lists can have at most %d entries"

SQLSTATE: 54000

Description: The number of attributes in the target list exceeds 1664.

Solution: Reduce the number of attributes in the target list.

GAUSS-00013: "cache lookup failed for type %u"

SQLSTATE: 22P06

Description: The operator is invalid.

Solution: Ensure that the operator in the SQL statement is valid.

GAUSS-00014: "cannot subscript type %s because it is not an array"

SQLSTATE: 42804

Description: A subscript operation is performed on a non-array type.

Solution: Do not perform a subscript operation on a non-array type.

GAUSS-00015: "array subscript must have type integer"

SQLSTATE: 42804

Description: The array subscript is incorrect.

Solution: Ensure that the array subscript is an integer.

GAUSS-00016: "array assignment requires type %s but expression is of type %s"

SQLSTATE: 42804

Description: When you set variables of an array type, variables cannot be converted.

Solution: Reassign values to variables. Provide a conversion function so that variables of an array type can be converted. Obtain related information from the pg_cast system catalog.

GAUSS-00017: "unrecognized node type: %d"

SQLSTATE: XX004

Description:Internal system error.

Solution:Contact technical support.

GAUSS-00018: "failed to find conversion function from %s to %s"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-00020: "cache lookup failed for function %u"

SQLSTATE: 22P06

Description: The function with the corresponding ID is not found in the system catalog.

Solution: Ensure that no concurrent sessions perform a drop, cancel, or replace operation on the function.


GAUSS-00021 – GAUSS-00030


GAUSS-00021: "unsupported pathtype %d in build_coercion_expression"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-00022: "cannot cast type %s to %s"

SQLSTATE: 42846

Description: Two types cannot be converted to each other.

Solution: Provide a type conversion function. Obtain related information from the pg_cast system catalog.

GAUSS-00024: "argument of %s must not return a set"

SQLSTATE: 42804

Description: A set cannot be returned.

Solution: Ensure that the expression can return a set.

GAUSS-00025: "argument of %s must be type %s, not type %s"

SQLSTATE: 42804

Description: The source and target types are different and cannot be converted.

Solution: Ensure that the source and target types are compatible and can be convertible.

GAUSS-00026: "%s types %s and %s cannot be matched"

SQLSTATE: 42804

Description: The two types do not belong to the same category.

Solution: Check the typcategory column in the pg_type system catalog for the category of each type.

GAUSS-00027: "%s could not convert type %s to %s"

SQLSTATE: 42846

Description: The source and target types are different and cannot be converted.

Solution: Ensure that the source and target types are compatible and can be convertible.

GAUSS-00028: "arguments declared 'anyelement' are not all alike"

SQLSTATE: 42804

Description: A function uses pseudo-type parameters, but the types of elements in an array are different from the defined ones.

Solution: Ensure that the types of elements in an array are same as the defined ones.

GAUSS-00029: "arguments declared 'anyarray' are not all alike"

SQLSTATE: 42804

Description: A function uses pseudo-type parameters, but the types of elements in an array are different from the defined ones.

Solution: Ensure that the types of elements in an array are same as the defined ones.

GAUSS-00030: "arguments declared 'anyrange' are not all alike"

SQLSTATE: 42804

Description: A function uses pseudo-type parameters, but the types of elements in an array are different from the defined ones.

Solution: Ensure that the types of elements in an array are same as the defined ones.


GAUSS-00031 – GAUSS-00040


GAUSS-00031: "argument declared 'anyarray' is not an array but type %s"

SQLSTATE: 42804

Description: The type of the declared parameter is inconsistent with that of the input parameter.

Solution: Use an input parameter of the same type as the declared parameter.

GAUSS-00032: "argument declared 'anyarray' is not consistent with argument declared 'anyelement'"

SQLSTATE: 42804

Description: The array type defined does not match the types of elements in an ANY array.

Solution: Ensure that the array type defined in the query statement and the types of elements in an ANY array are correct.

GAUSS-00033: "argument declared 'anyrange' is not a range but type %s"

SQLSTATE: 42804

Description: The range type defined does not match the types of elements in an ANY range.

Solution: Ensure that the range type defined in the query statement and the types of elements in an ANY range are correct.

GAUSS-00034: "argument declared 'anyrange' is not consistent with argument declared 'anyelement'"

SQLSTATE: 42804

Description: The parameter type is different from the declared parameter type.

Solution: Use a parameter of the declared type.

GAUSS-00035: "could not determine polymorphic type because input has type 'unknown'"

SQLSTATE: 42804

Description: Array element types cannot be identified.

Solution: Ensure that the array element types in the ANY predicate are correct.

GAUSS-00036: "type matched to anynonarray is an array type: %s"

SQLSTATE: 42804

Description: The required type is not array.

Solution: Internal system error. Contact technical support.

GAUSS-00037: "type matched to anyenum is not an enum type: %s"

SQLSTATE: 42804

Description: The required type is ENUM.

Solution: Ensure that an ENUM-type value is used for the parameter of the ANYENUM type.

GAUSS-00038: "could not find range type for data type %s"

SQLSTATE: 42704

Description: The declared array type is range, but the input value is not of the range type.

Solution: Assign a value of the defined type to the array.

GAUSS-00039: "could not determine polymorphic type because context isn't polymorphic"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-00040: "unrecognized castcontext: %d"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.


GAUSS-00041 – GAUSS-00050


GAUSS-00041: "unrecognized castmethod: %d"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-00042: "cache lookup failed for relation %u"

SQLSTATE: XX000

Description: When ALTER TABLE SET TABLESPACE is run, the relational table does not exist.

Solution: Modify this operation.

GAUSS-00043: "unsafe use of string constant with Unicode escapes"

SQLSTATE: 0A000

Description: When standard_conforming_strings is set to off, the string constant is defined as an escape character of unified codes.

Solution: 1. Check whether the escape string in the input statement is correct. 2. Set standard_conforming_strings to on using gsql.

GAUSS-00044: "invalid Unicode escape"

SQLSTATE: 22025

Description: The input statement contains an invalid escape character sequence.

Solution: Check whether a character sequence similar to \uXXXX or \UXXXXXXXXX exists. X indicates a digit (0–9), uppercase letter (A–F), or lowercase letter (a–f).

GAUSS-00045: "unsafe use of \' in a string literal"

SQLSTATE: 22P06

Description: A string uses an invalid escape character ().

Solution: Correct the invalid escape character () used in the SQL syntax.

GAUSS-00046: "%s at end of input"

SQLSTATE: 42601

Description: The syntax of the terminator in the specified statement is incorrect.

Solution: Ensure that the syntax of the input statement is correct.

GAUSS-00047: "%s at or near '%s'"

SQLSTATE: 42601

Description: Syntax error.

Solution: Correct the syntax of the SQL statement to be executed.

GAUSS-00048: "core_yylex_init() failed: %m"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-00049: "invalid hexadecimal digit"

SQLSTATE: XX000

Description: Invalid format.

Solution: Modify the input SQL statement.


GAUSS-00051 – GAUSS-00060


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

SQLSTATE: 42703

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

Solution: Run \d tblname 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 functions are defined in the pg_type system catalog for a 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: The collation does not match the type, and the input is incorrect.

Solution: Modify the input SQL statement.

GAUSS-00059: "typeTypeId() called with NULL type struct"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-00060: "invalid type name '%s'"

SQLSTATE: 42601

Description: The specified type is invalid.

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


GAUSS-00061 – GAUSS-00070


GAUSS-00061: "unrecognized A_Expr kind: %d"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-00062: "column %s.%s does not exist"

SQLSTATE: 42703

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

Solution: Run \d tblname 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-00063: "column '%s' not found in data type %s"

SQLSTATE: 42703

Description: The type of the specified column is incorrectly defined.

Solution: Run \d tblname to check whether the type of the column in the table is correct.

GAUSS-00064: "could not identify column '%s' in record data type"

SQLSTATE: 42703

Description: The column does not exist because it cannot be identified using the record data type.

Solution: Ensure that the column exists.

GAUSS-00065: "column notation .%s applied to type %s, which is not a composite type"

SQLSTATE: 42809

Description: A non-composite type member is accessed using a dot (.).

Solution: Do not use a dot (.) to access a non-composite type member.

GAUSS-00066: "row expansion via '*' is not supported here"

SQLSTATE: 0A000

Description: The current context does not support unfolding columns using an asterisk (*).

Solution: Do not use an asterisk (*) to unfold columns in the current context.

GAUSS-00067: "column reference '%s' is ambiguous"

SQLSTATE: 42702

Description: A column is referenced multiple times.

Solution: Do not reference a column multiple times.

GAUSS-00068: "column '%s' does not exist"

SQLSTATE: 42703

Description: The column does not exist.

Solution: Ensure that the column to be used exists in the table definition.

GAUSS-00069: "cross-database references are not implemented: %s"

SQLSTATE: 0A000

Description: An object cannot be referenced from a database to another.

Solution: Do not reference an object from a database to another. For example, do not access an object in Database1 from Database2 using Database1.schema.object. The object can be a table, index, or view.

GAUSS-00070: "improper qualified name (too many dotted names): %s"

SQLSTATE: 42601

Description: Excessive dot separators are used. As a result, the name cannot be correctly resolved.

Solution: Reduce the number of dot separators and try again.


GAUSS-00071 – GAUSS-00080


GAUSS-00071: "there is no parameter $%d"

SQLSTATE: 42P02

Description: The parameter sequence number is invalid.

Solution: Ensure that the parameter sequence number is within the range.

GAUSS-00072: "NULLIF requires = operator to yield Boolean"

SQLSTATE: 42804

Description: When comparing parameters in the NULLIF expression, the return value of the function used is not of the Boolean type.

Solution: Ensure that the return value of the function is a Boolean type.

GAUSS-00073: "arguments of row IN must all be row expressions"

SQLSTATE: 42601

Description: The parameter in the IN expression is neither of the array type nor a row expression.

Solution: Ensure that the parameter is an array type or a row expression.

GAUSS-00074: "unexpected non-SELECT command in SubLink"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-00075: "subquery must return a column"

SQLSTATE: 42601

Description: No columns are returned for a subquery.

Solution: Ensure that at least one column is returned for a subquery.

GAUSS-00076: "subquery must return only one column"

SQLSTATE: 42601

Description: When a subquery is used as a sub-expression, more than one column is returned.

Solution: Ensure that only one column is returned.

GAUSS-00077: "subquery has too many columns"

SQLSTATE: 42601

Description: In a row expression, the number of columns returned for a subquery is more than the number of required columns.

Solution: Ensure that the number of columns returned is the same as the number of required columns.

GAUSS-00078: "subquery has too few columns"

SQLSTATE: 42601

Description: In a row expression, the number of columns returned for a subquery is less than the number of required columns.

Solution: Ensure that the number of columns returned is the same as the number of required columns.

GAUSS-00079: "cannot determine type of empty array"

SQLSTATE: 42P18

Description: The type of an empty array cannot be determined.

Solution: Forcibly convert the data type.

GAUSS-00080: "could not find element type for data type %s"

SQLSTATE: 42704

Description: The type of an element in the array is invalid.

Solution: Ensure that the type of an element stored in the array is the same as the specified one.


GAUSS-00081 – GAUSS-00090


GAUSS-00081: "unnamed XML attribute value must be a column reference"

SQLSTATE: 42601

Description: The unnamed XML attribute values must be referenced by a column.

Solution: Modify the input SQL statement.

GAUSS-00082: "XML attribute name '%s' appears more than once"

SQLSTATE: 42601

Description: A duplicate column exists in XMLELEMENT.

Solution: Modify the input SQL statement.

GAUSS-00083: "cannot cast XMLSERIALIZE result to %s"

SQLSTATE: 42846

Description: The XMLSERIALIZE type is converted to another type.

Solution: Ensure that types can be converted.

GAUSS-00084: "unrecognized booltesttype: %d"

SQLSTATE: XX004

Description:Internal system error.

Solution:Contact technical support.

GAUSS-00085: "WHERE CURRENT OF clause not yet supported"

SQLSTATE: 54001

Description: The WHERE CURRENT OF syntax is used, which is not supported.

Solution: Do not use the WHERE CURRENT OF syntax.

GAUSS-00086: "unequal number of entries in row expressions"

SQLSTATE: 42601

Description: In a row expression, the number of parameters on the right and that on the left of the equal to (et) operator are different.

Solution: Ensure that the numbers are the same.

GAUSS-00087: "cannot compare rows of zero length"

SQLSTATE: 0A000

Description: The lengths of rows to be compared are zero.

Solution: Ensure that the lengths are not zero.

GAUSS-00088: "row comparison operator must yield type Boolean, not type %s"

SQLSTATE: 42804

Description: The value returned after row expression comparison is not a Boolean type.

Solution: Ensure that the value returned is a Boolean type.

GAUSS-00089: "row comparison operator must not return a set"

SQLSTATE: 42804

Description: The value returned after row expression comparison is a set.

Solution: Ensure that the value returned is not a set.

GAUSS-00090: "could not determine interpretation of row comparison operator %s"

SQLSTATE: 0A000

Description: The row comparison operator cannot be found.

Solution: Ensure that the row comparison operator to be used exists.


GAUSS-00091 – GAUSS-00100


GAUSS-00091: "IS DISTINCT FROM requires = operator to yield Boolean"

SQLSTATE: 42804

Description: In the IS DISTINCT FROM statement, the value returned for the operator used for deduplication is not of the Boolean type.

Solution: Ensure that the value returned is a Boolean type.

GAUSS-00092: "collation mismatch between implicit collations '%s' and '%s'"

SQLSTATE: 42P21

Description: Two character sets cannot be converted in implicit mode.

Solution: Ensure that two character sets to be converted are compatible.

GAUSS-00093: "collation mismatch between explicit collations '%s' and '%s'"

SQLSTATE: 42P21

Description: Two character sets cannot be converted in explicit mode.

Solution: Ensure that two character sets to be converted are compatible.

GAUSS-00094: "table reference '%s' is ambiguous"

SQLSTATE: 42P09

Description: Table reference is ambiguous because duplicate table names exist.

Solution: Provide a specific table name when referencing a table.

GAUSS-00095: "table reference %u is ambiguous"

SQLSTATE: 42P09

Description: Table reference is ambiguous because duplicate table names exist.

Solution: Provide a specific table name when referencing a table.

GAUSS-00096: "table name '%s' specified more than once"

SQLSTATE: 42712

Description: In the FROM clause, the same table is used multiple times without an alias.

Solution: Specify an alias for the table so that it can be used multiple times.

GAUSS-00097: "RTE not found (internal error)"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-00098: "bad levelsup for CTE '%s'"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-00099: "could not find CTE '%s'"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.