GAUSS-01431 -- GAUSS-01440

GAUSS-01431: “operator class '%s' for access method '%s' already exists”

SQLSTATE: 42710

Description: During CREATE OPERATOR CLASS execution, the defined operator class already exists.

Solution: Ensure that the operator class name is unique.

GAUSS-01432: “could not make operator class '%s' be default for type %s”

SQLSTATE: 42710

Description: During CREATE OPERATOR CLASS execution, the default operator class has been created for a data type.

Solution: Ensure that no default operator class has been created for a data type.

GAUSS-01433: “must be system admin to create an operator family”

SQLSTATE: 42501

Description: A non-administrator user executes the CREATE OPERATOR FAMILY statement.

Solution: Execute the statement as a system administrator.

GAUSS-01434: “must be system admin to alter an operator family”

SQLSTATE: 42501

Description: A non-administrator user executes the ADD or DROP clause of the ALTER OPERATOR FAMILY statement.

Solution: Execute the clause as a system administrator.

GAUSS-01435: “operator argument types must be specified in ALTER OPERATOR FAMILY”

SQLSTATE: 42601

Description: In the ADD OPERATOR clause of the ALTER OPERATOR FAMILY statement, the operator parameter type is not specified.

Solution: Specify the operator parameter type.

GAUSS-01436: “STORAGE cannot be specified in ALTER OPERATOR FAMILY”

SQLSTATE: 42601

Description: In the ADD clause of the ALTER OPERATOR FAMILY … ADD statement, a STORAGE clause is specified.

Solution: Do not specify a STORAGE clause.

GAUSS-01437: “one or two argument types must be specified”

SQLSTATE: 42601

Description: In the ADD or DROP clause of the CREATE OPERATOR CLASS or ALTER OPERATOR FAMILY statement, more than two operators or functions are specified.

Solution: Specify only one or two operators or functions.

GAUSS-01438: “index operators must be binary”

SQLSTATE: 42P17

Description: In the ADD clause of the CREATE OPERATOR CLASS or ALTER OPERATOR FAMILY statement, the specified operator is not a binary operator.

Solution: The specified operator must be a binary operator.

GAUSS-01439: “access method '%s' does not support ordering operators”

SQLSTATE: 42P17

Description: In the ADD clause of the CREATE OPERATOR CLASS or ALTER OPERATOR FAMILY statement, a sort operator is specified, but access_method does not support sorting.

Solution: Ensure that access_method supports sorting so that operators can be ordered.

GAUSS-01440: “index search operators must return Boolean”

SQLSTATE: 42P17

Description: In the ADD OPERATOR…FOR SEARCH clause of the CREATE OPERATOR CLASS or ALTER OPERATOR FAMILY statement, the returned operator value is not a Boolean type.

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

Feedback
编组 3备份
    openGauss 2024-07-23 01:01:16
    cancel