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

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 typlen, typbyval, and typalign in the pg_type system catalog for the source data type are the same as those for the target data type.)

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: When creating a CAST function, do not use the composite data type as the source data type 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: Whiling 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.