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

GAUSS-01451 -- GAUSS-01460

GAUSS-01451: "function %d(%s,%s) already exists in operator family '%s'"

SQLSTATE: 42710

Description: During execution of CREATE OPERATOR CLASS, ALTER OPERATOR FAMILY ... ADD/DROP function, a function to be added already exists.

Solution: Ensure that the function to be added does not exist in the operator family.

GAUSS-01452: "operator %d(%s,%s) does not exist in operator family '%s'"

SQLSTATE: 42704

Description: The operator specified in ALTER OPERATOR FAMILY ... DROP operator does not exist in the family.

Solution: Ensure that the operator to be dropped exists in the specified operator family.

GAUSS-01453: "function %d(%s,%s) does not exist in operator family '%s'"

SQLSTATE: 42704

Description: In ALTER OPERATOR FAMILY ... DROP function, the specified function does not exist.

Solution: Ensure that the function to be dropped exists in the specified operator family.

GAUSS-01454: "could not find tuple for amop entry %u"

SQLSTATE: XX000

Description: Internal system error.

Solution: Contact technical support.

GAUSS-01455: "could not find tuple for amproc entry %u"

SQLSTATE: XX000

Description: Internal system error.

Solution: Contact technical support.

GAUSS-01456: "operator class '%s' for access method '%s' already exists in schema '%s'"

SQLSTATE: 42710

Description: During execution of ALTER OPERATOR CLASS name USING index_method RENAME TO new_name, the new name exists in the new schema.

Solution: Ensure that the new name does not exist in the new schema.

GAUSS-01457: "operator family '%s' for access method '%s' already exists in schema '%s'"

SQLSTATE: 42710

Description: In ALTER OPERATOR FAMILY name USING index_method RENAME TO new_name, the new name exists in the new schema.

Solution: Ensure that the new name does not exist in the new schema.

GAUSS-01458: "SETOF type not allowed for operator argument"

SQLSTATE: 42P13

Description: In CREATE OPERATOR, the type of the left or right parameter is SETOF (set).

Solution: Ensure that none of the left and right parameters belong to the SETOF type (set).

GAUSS-01459: "operator procedure must be specified"

SQLSTATE: 42P13

Description: In CREATE OPERATOR, no procedure is specified.

Solution: Specify procedure for the CREATE OPERATOR statement.

GAUSS-01460: "at least one of leftarg or rightarg must be specified"

SQLSTATE: 42P13

Description: In CREATE OPERATOR, both LEFTARG and RIGHTARG are not specified.

Solution: Specify either of LEFTARG and RIGHTARG or both of them for the CREATE OPERATOR statement.