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

GAUSS-01431 -- GAUSS-01440

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

SQLSTATE: 42710

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

Solution: Ensure that the name of the OPERATOR CLASS to be created 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 the data type when the user is to create the default OPERATOR CLASS for a specific data type using the keyword.

Solution: Ensure that no default OPERATOR CLASS has been created for a specific data type in the above scenario.

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 CREATE OPERATOR FAMILY 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 clauses of the ALTER OPERATOR FAMILY statement.

Solution: Execute the ADD or DROP clauses of the ALTER OPERATOR FAMILY statement as a system administrator.

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

SQLSTATE: 42601

Description: The parameter type of OPERATOR is not specified for the ADD OPERATOR clause of the ALTER OPERATOR FAMILY statement.

Solution: Specify the parameter type of OPERATOR for the ADD OPERATOR clause of the ALTER OPERATOR FAMILY statement.

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

SQLSTATE: 42601

Description: During execution of ALTER OPERATOR FAMILY ... ADD to add a function, STORAGE is specified in the clause.

Solution: Do not specify the STORAGE clause for the ADD clause of the ALTER OPERATOR FAMILY statement.

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

SQLSTATE: 42601

Description: More than two OPERATOR or FUNCTION parameters are specified for the ADD or DROP clauses in the CREATE OPERATOR CLASS or ALTER OPERATOR FAMILY statement.

Solution: Ensure that only one or two OPERATOR or FUNCTION parameters are specified for the ADD or DROP clauses in the CREATE OPERATOR CLASS or ALTER OPERATOR FAMILY statement.

GAUSS-01438: "index operators must be binary"

SQLSTATE: 42P17

Description: The OPERATOR specified for the ADD clause in the CREATE OPERATOR CLASS or ALTER OPERATOR FAMILY statement is not binary.

Solution: Ensure that the OPERATOR specified for the ADD clause in the CREATE OPERATOR CLASS or ALTER OPERATOR FAMILY statement is binary.

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

SQLSTATE: 42P17

Description: The ADD clause specifies SORT OPERATOR in the CREATE OPERATOR CLASS or ALTER OPERATOR FAMILY statement. However, access_method does not support SORT OPERATOR.

Solution: Only when access_method supports SORT OPERATOR, FOR ORDER can be specified. Otherwise, FOR SERACH is specified.

GAUSS-01440: "index search operators must return boolean"

SQLSTATE: 42P17

Description: FOR SEARCH is specified for the ADD OPERATOR clause in the CREATE OPERATOR CLASS or ALTER OPERATOR FAMILY statement, but the operator does not return boolean values.

Solution: Ensure that the operator FOR SEARCH specified for the ADD OPERATOR clause in the CREATE OPERATOR CLASS or ALTER OPERATOR FAMILY statement returns boolean values.