MogDB
Ecological Tools
Doc Menu

GAUSS-00901 – GAUSS-01000


GAUSS-00901 – GAUSS-00910


GAUSS-00901: "tables in ALTER TABLE EXCHANGE PARTITION must have the same column/row storage"

SQLSTATE: 0A000

Description: Tables in the ALTER TABLE EXCHANGE PARTITION statement use both row and column storage.

Solution: Ensure that tables specified in the ALTER TABLE EXCHANGE PARTITION statement use the same storage mode.

GAUSS-00902: "tables in ALTER TABLE EXCHANGE PARTITION must have the same type of compress"

SQLSTATE: 0A000

Description: Tables in the ALTER TABLE EXCHANGE PARTITION statement use different compression types.

Solution: Ensure that tables in the ALTER TABLE EXCHANGE PARTITION statement have the same compression type.

GAUSS-00903: "tables in ALTER TABLE EXCHANGE PARTITION must have the same number of columns"

SQLSTATE: 0A000

Description: Tables in the ALTER TABLE EXCHANGE PARTITION statement have different numbers of columns.

Solution: Ensure that tables in the ALTER TABLE EXCHANGE PARTITION statement have the same number of columns.

GAUSS-00904: "column name mismatch in ALTER TABLE EXCHANGE PARTITION"

SQLSTATE: 0A000

Description: Tables in the ALTER TABLE EXCHANGE PARTITION have different column names.

Solution: Ensure that tables in the ALTER TABLE EXCHANGE PARTITION statement have the same column name.

GAUSS-00905: "column type or size mismatch in ALTER TABLE EXCHANGE PARTITION"

SQLSTATE: 0A000

Description: Tables in the ALTER TABLE EXCHANGE PARTITION statement have different column types or sizes.

Solution: Ensure that tables in the ALTER TABLE EXCHANGE PARTITION statement have the same column type and size.

GAUSS-00906: "column not null constraint mismatch in ALTER TABLE EXCHANGE PARTITION"

SQLSTATE: 0A000

Description: Tables in the ALTER TABLE EXCHANGE PARTITION statement have different NOT NULL column attributes.

Solution: Ensure that tables in the ALTER TABLE EXCHANGE PARTITION statement have the same NOT NULL column attribute.

GAUSS-00907: "column default constraint mismatch in ALTER TABLE EXCHANGE PARTITION"

SQLSTATE: 0A000

Description: Tables in the ALTER TABLE EXCHANGE PARTITION statement have different default column constraints.

Solution: Ensure that tables in the ALTER TABLE EXCHANGE PARTITION statement have the same default column constraint.

GAUSS-00908: "column collation mismatch in ALTER TABLE EXCHANGE PARTITION"

SQLSTATE: 0A000

Description: Tables in the ALTER TABLE EXCHANGE PARTITION statement have different column orders.

Solution: Ensure that tables in the ALTER TABLE EXCHANGE PARTITION statement have the same column order.

GAUSS-00909: "column storage mismatch in ALTER TABLE EXCHANGE PARTITION"

SQLSTATE: 0A000

Description: Tables in the ALTER TABLE EXCHANGE PARTITION statement have different column storage settings.

Solution: Ensure that tables in the ALTER TABLE EXCHANGE PARTITION statement have the same column storage setting.

GAUSS-00910: "the type of column compress mismatch in ALTER TABLE EXCHANGE PARTITION"

SQLSTATE: 0A000

Description: Tables in the ALTER TABLE EXCHANGE PARTITION statement have different column compression types.

Solution: Ensure that tables in the ALTER TABLE EXCHANGE PARTITION statement have the same compression type.


GAUSS-00911 – GAUSS-00920


GAUSS-00911: "constraint mismatch in ALTER TABLE EXCHANGE PARTITION"

SQLSTATE: 0A000

Description: Tables in the ALTER TABLE EXCHANGE PARTITION statement have different column constraints.

Solution: Ensure that tables in the ALTER TABLE EXCHANGE PARTITION statement have the same column constraint.

GAUSS-00912: "distribute mismatch for tables in ALTER TABLE EXCHANGE PARTITION"

SQLSTATE: 0A000

Description: Tables in the ALTER TABLE EXCHANGE PARTITION statement have different column distribution settings.

Solution: Ensure that tables in the ALTER TABLE EXCHANGE PARTITION statement have the same column distribution setting.

GAUSS-00913: "tables in ALTER TABLE EXCHANGE PARTITION must have the same number of indexs"

SQLSTATE: 0A000

Description: Tables in the ALTER TABLE EXCHANGE PARTITION statement have different numbers of indexes.

Solution: Ensure that tables in the ALTER TABLE EXCHANGE PARTITION statement have the same number of indexes.

GAUSS-00914: "index mismatch for tables in ALTER TABLE EXCHANGE PARTITION"

SQLSTATE: 0A000

Description: Tables in the ALTER TABLE EXCHANGE PARTITION statement have different indexes.

Solution: Ensure that tables in the ALTER TABLE EXCHANGE PARTITION statement have the same index.

GAUSS-00915: "some rows in table do not qualify for specified partition"

SQLSTATE: 0A000

Description: When SPLIT PARTITION is run, some rows in the tables cannot be split.

Solution: Locate the cause.

GAUSS-00916: "the number of resulting partitions must be more than one"

SQLSTATE: 42601

Description: The number of specified partitions is less than two when one partition is split into multiple partitions.

Solution: Ensure that the number of specified partitions is no less than two.

GAUSS-00917: "the bound of the first resulting partition is too low"

SQLSTATE: 42601

Description: Partitioning failed because the first partition border value is too low.

Solution: Ensure that the SPLIT PARTITION operation is correct.

GAUSS-00918: "the bound of resulting partition '%s' is too low"

SQLSTATE: 42601

Description: Partitioning failed because the partition border value is too low.

Solution: Ensure that the SPLIT PARTITION operation is correct.

GAUSS-00919: "the bound of the last resulting partition is not equal with specified partition bound"

SQLSTATE: 42601

Description: Partitioning failed because the last border value is inconsistent with the specific one.

Solution: Ensure that the SPLIT PARTITION operation is correct.

GAUSS-00920: "number of boundary items NOT EQUAL to number of partition keys"

SQLSTATE: 42601

Description: Partition failed because the number of specified partition key attributes is inconsistent with that of original partition key attributes.

Solution: Ensure that the SPLIT PARTITION operation is correct.


GAUSS-00921 – GAUSS-00930


GAUSS-00921: "split point is too low"

SQLSTATE: 0A000

Description: After SPLIT PARTITION is run, the split point value is smaller than the border value of the previous partition.

Solution: Ensure that the SPLIT PARTITION operation is correct.

GAUSS-00922: "split point is too high"

SQLSTATE: 0A000

Description: After SPLIT PARTITION is run, the split point value is greater than the border value of the next partition.

Solution: Ensure that the SPLIT PARTITION operation is correct.

GAUSS-00923: "resulting partition '%s' name conflicts with that of an existing partition"

SQLSTATE: 42710

Description: After SPLIT PARTITION is run, the partition names conflict with the existing partition names.

Solution: Rename the partitions.

GAUSS-00924: "number of boundary items NOT EQUAL to number of partition keys"

SQLSTATE: 42601

Description: Partition failed because the number of specified partition key attributes is inconsistent with that of original partition key attributes.

Solution: Ensure that the SPLIT PARTITION operation is correct.

GAUSS-00925: "cache lookup failed for toast table: %u"

SQLSTATE: XX000

Description: The required toast table is not found.

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

GAUSS-00926: "cache lookup failed for cuDesc table: %u"

SQLSTATE: XX000

Description: The required cuDesc table is not found.

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

GAUSS-00927: "cache lookup failed for delta table: %u"

SQLSTATE: XX000

Description: The required delta table is not found.

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


GAUSS-00931 – GAUSS-00940


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

SQLSTATE: 02000

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

Solution: Modify this operation.

GAUSS-00936: "SQL function cannot return shell type %s"

SQLSTATE: 42P13

Description: The SQL function does not return a shared variable.

Solution: Modify the SQL function and do not use a shared variable as a return value.

GAUSS-00937: "SQL function cannot accept shell type %s"

SQLSTATE: 42P13

Description: The SQL function does not use a shared variable as the function parameter.

Solution: Modify the SQL function, and do not use a shared variable as a function parameter.

GAUSS-00938: "type %s does not exist"

SQLSTATE: 42704

Description: The data type does not exist.

Solution: Check the function or storage process and verify that the parameter data type is correct.

GAUSS-00940: "VARIADIC parameter must be the last input parameter"

SQLSTATE: 42P13

Description:VARIADIC must be put at the end of input parameters.

Solution: Put VARIADIC at the end of input parameters.


GAUSS-00941 – GAUSS-00950


GAUSS-00941: "VARIADIC parameter must be an array"

SQLSTATE: 42P13

Description:VARIADIC parameters must be of the array type.

Solution: Use variables of the array type as VARIADIC parameters.

GAUSS-00942: "parameter name '%s' used more than once"

SQLSTATE: 42P13

Description: A parameter name is used more than once in the parameter list.

Solution: Use different parameter names.

GAUSS-00943: "only input parameters can have default values"

SQLSTATE: 42P13

Description: A default value exists only when the parameter is set.

Solution: Only define a default value for the input parameter.

GAUSS-00944: "cannot use table references in parameter default value"

SQLSTATE: 42P10

Description: Variables cannot be used as default values of parameters, such as tables, columns, and CurrentOf expressions.

Solution: Do not use variables as default values.

GAUSS-00945: "cannot use subquery in parameter default value"

SQLSTATE: 0A000

Description: Subqueries cannot be used as default values of parameters.

Solution: Do not use subqueries as default values.

GAUSS-00946: "cannot use aggregate function in parameter default value"

SQLSTATE: 42803

Description: Aggregate functions cannot be used as default values of parameters.

Solution: Do not use aggregate functions as default values.

GAUSS-00947: "cannot use window function in parameter default value"

SQLSTATE: 42P20

Description: Window functions cannot be used as default values of parameters.

Solution: Do not use window functions as default values.

GAUSS-00948: "invalid volatility '%s'"

SQLSTATE: XX000

Description: The type of the volatile function is invalid.

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

GAUSS-00949: "no function body specified"

SQLSTATE: 42P13

Description: No function body is defined.

Solution: Ensure that the function body is defined.

GAUSS-00950: "no language specified"

SQLSTATE: 42P13

Description: No language type of the function is defined, such as C/PLPGSQL/SQL.

Solution: Define the language type such as C/PLPGSQL/SQL.


GAUSS-00951 – GAUSS-00960


GAUSS-00951: "COST must be positive"

SQLSTATE: 22023

Description: The value of COST must be a positive number.

Solution: Ensure that the value of COST is a positive number.

GAUSS-00952: "ROWS must be positive"

SQLSTATE: 22023

Description: The value of ROWS must be a positive number.

Solution: Ensure that the value of ROWS is a positive number.

GAUSS-00953: "only one AS item needed for language '%s'"

SQLSTATE: 42P13

Description: Only one AS clause is required.

Solution: Ensure that only one AS clause exists.

GAUSS-00954: "language '%s' does not exist"

SQLSTATE: 42704

Description: The language does not exist.

Solution: Check the function definition and ensure that the language type of the function is supported by the database, such as PL/pgSQL and SQL.

GAUSS-00955: "only system admin can define a leakproof function"

SQLSTATE: 42501

Description: Only the system administrator can define a leakproof function.

Solution: Create a leakproof function as a system administrator.

GAUSS-00957: "function result type cannot be a view."

SQLSTATE: 42P13

Description: The return type of the function cannot be a view.

Solution: Check the function definition, and do not use a view as the return type of the function.

GAUSS-00958: "ROWS is not applicable when function does not return a set"

SQLSTATE: 22023

Description:ROWS is specified, but the function does not return a result set.

Solution: Specify ROWS only for functions that return result sets.

GAUSS-00959: "cache lookup failed for pg_aggregate tuple for function %u"

SQLSTATE: XX000

Description: The required aggregate function is not found in the pg_aggregate system catalog.

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

GAUSS-00960: "function %u doesn't return OPAQUE"

SQLSTATE: XX000

Description: The function return type is not opaque.

Solution: Check whether the function return type is correct.


GAUSS-00961 – GAUSS-00970


GAUSS-00962: "source data type %s is a pseudo-type"

SQLSTATE: 42809

Description: The source data type is a pseudo type.

Solution: Check the CAST function to be created and ensure that the source data type is not a pseudo type.

GAUSS-00963: "target data type %s is a pseudo-type"

SQLSTATE: 42809

Description: The target data type is a pseudo type.

Solution: Check the CAST function to be created and ensure that the target data type is not a pseudo type.

GAUSS-00964: "must be owner of type %s or type %s"

SQLSTATE: 42501

Description: The user executing this statement is not the owner of the source type and target type.

Solution: Check the SQL statement and ensure that the user is the owner of the source type and target type.

GAUSS-00965: "cast function must take one to three arguments"

SQLSTATE: 42P17

Description: The CAST function does not specify one to three parameters.

Solution: Ensure that the CAST function specifies one to three parameters.

GAUSS-00966: "argument of cast function must match or be binary-coercible from source data type"

SQLSTATE: 42P17

Description: The parameters of the CAST function neither match the source data type nor are compatible with the binary.

Solution: Ensure that the parameters of the CAST function match the source data type or are compatible with the binary.

GAUSS-00967: "second argument of cast function must be type integer"

SQLSTATE: 42P17

Description: The second parameter of the CAST function is not of an integer type.

Solution: Ensure that the second parameter of the CAST function is of an integer type.

GAUSS-00968: "third argument of cast function must be type Boolean"

SQLSTATE: 42P17

Description: The third parameter of the CAST function is not of a Boolean type.

Solution: Ensure that the third parameter of the CAST function is of a Boolean type.

GAUSS-00969: "return data type of cast function must match or be binary-coercible to target data type"

SQLSTATE: 42P17

Description: The return data type of the CAST function neither matches the target data type nor is binary-coercible to target data type.

Solution: Ensure that the return data type of the CAST function matches or is binary-coercible to target data type.

GAUSS-00970: "cast function must not be volatile"

SQLSTATE: 42P17

Description: The CAST function is volatile.

Solution: Ensure that the CAST function is operating properly.


GAUSS-00971 – GAUSS-00980


GAUSS-00971: "cast function must not be an aggregate function"

SQLSTATE: 42P17

Description: The function is an aggregate function.

Solution: Ensure that the CAST function is not an aggregate function.

GAUSS-00972: "cast function must not be a window function"

SQLSTATE: 42P17

Description: The function is a window function.

Solution: Ensure that the function is not a window function.

GAUSS-00973: "cast function must not return a set"

SQLSTATE: 42P17

Description: The function returns a result set.

Solution: Ensure that the CAST function does not return a result set.

GAUSS-00974: "must be system admin to create a cast WITHOUT FUNCTION"

SQLSTATE: 42501

Description: The WITHOUT FUNCTION attribute of the CAST function can be specified only by the system administrator.

Solution: Specify the WITHOUT FUNCTION attribute as a system administrator while creating the CAST function.

GAUSS-00975: "source and target data types are not physically compatible"

SQLSTATE: 42P17

Description: The source and target data types are not physically compatible. (Physical compatibility means source and target data types of typlen, typbyval, and typalign in the pg_type system catalog are the same.)

Solution: Ensure that the source and target data types are physically compatible.

GAUSS-00976: "composite data types are not binary-compatible"

SQLSTATE: 42P17

Description: The composite data type is not binary-compatible and cannot be converted.

Solution: While creating a CAST function, do not use the composite data type as the source or target data type.

GAUSS-00977: "enum data types are not binary-compatible"

SQLSTATE: 42P17

Description: The enum data type is not binary-compatible and cannot be converted.

Solution: While creating a CAST function, do not use the enum data type as the source or target data type.

GAUSS-00978: "array data types are not binary-compatible"

SQLSTATE: 42P17

Description: The array data type is not binary-compatible and cannot be converted.

Solution: While creating a CAST function, do not use the array data type as the source or target data type.

GAUSS-00979: "domain data types must not be marked binary-compatible"

SQLSTATE: 42P17

Description: The domain data types are not binary-compatible and cannot be converted.

Solution: While creating a CAST function, do not use the domain data type as the source or target data type.

GAUSS-00980: "source data type and target data type are the same"

SQLSTATE: 42P17

Description: The source and target data types are the same.

Solution: While creating a CAST, ensure that the source and target data types are different.


GAUSS-00981 – GAUSS-00990


GAUSS-00981: "unrecognized CoercionContext: %d"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-00982: "cast from type %s to type %s already exists"

SQLSTATE: 42710

Description: The CAST function used for converting data from the source data type to the target data type already exists.

Solution: Do not create the CAST function again.

GAUSS-00983: "cast from type %s to type %s does not exist"

SQLSTATE: 42704

Description: The CAST function used for converting data from the source data type to the target data type does not exist.

Solution: Check the pg_cast system catalog to see whether the CAST function exists. If it does not exist, create it or rewrite the SQL statement to avoid using it.

GAUSS-00984: "could not find tuple for cast %u"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-00985: "function '%s' already exists in schema '%s'"

SQLSTATE: 42723

Description: The function in the target schema already exists.

Solution: Ensure that no function with the same name has been created in the target schema.

GAUSS-00986: "failed to change schema dependency for function '%s'"

SQLSTATE: XX000

Description: Failed to change the schema dependency of the function.

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

GAUSS-00987: "no inline code specified"

SQLSTATE: 42601

Description: Inline statements are not specified in an anonymous block.

Solution: Check the syntax of the anonymous block to ensure that it contains inline statements.

GAUSS-00988: "language '%s' does not support inline code execution"

SQLSTATE: 0A000

Description: Inline code cannot be executed for this language.

Solution: Use a common function or another language.

GAUSS-00989: "source encoding '%s' does not exist"

SQLSTATE: 42704

Description: The source encoding does not exist.

Solution: Ensure that the source encoding exists in the system.

GAUSS-00990: "destination encoding '%s' does not exist"

SQLSTATE: 42704

Description: The target encoding does not exist.

Solution: Ensure that the target encoding exists in the system.


GAUSS-00991 – GAUSS-01000


GAUSS-00991: "encoding conversion function %s must return type 'void'"

SQLSTATE: 42P17

Description: The code conversion function can only return void.

Solution: Check the code conversion function to ensure that the function only returns void.

GAUSS-00992: "cache lookup failed for conversion %u"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-00994: "extra data after last expected column"

SQLSTATE: 22P04

Description: The number of columns in the data file exceeds that in the table.

Solution: Ensure that the data file and the table have the same number of columns.

GAUSS-00995: "field position covers previous field"

SQLSTATE: 22P04

Description:Internal system error.

Solution:Contact technical support.

GAUSS-00998: "%s"

SQLSTATE: 42000

Description: Syntax error.

Solution: Ensure that the SQL statement syntax is correct.

GAUSS-01000: "type '%s' already exists"

SQLSTATE: 42710

Description: The data type already exists.

Solution: Check whether the data type exists in the pg_type system catalog.