Updated on 2023-12-22 GMT+08:00

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-00023: "argument of %s must be type boolean, not type %s"

SQLSTATE: 42804

Description: The function requires Boolean-type parameters, but its parameters cannot be converted to this type.

Solution: Ensure that the parameters used by the function are of the Boolean type, or provide a type conversion function.

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 converted to each other.

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 converted to each other.

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

SQLSTATE: 42804

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

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

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

SQLSTATE: 42804

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

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

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

SQLSTATE: 42804

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

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