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

GAUSS-00951 -- GAUSS-00960

GAUSS-00951: "COST must be positive"

SQLSTATE: 22023

Description: The values for COST must be positive numbers.

Solution: Check the function definition and ensure that the values for COST are positive numbers.

GAUSS-00952: "ROWS must be positive"

SQLSTATE: 22023

Description: The values for ROWS must be positive numbers.

Solution: Check the function definition and ensure that the values for ROWS are positive numbers.

GAUSS-00953: "only one AS item needed for language '%s'"

SQLSTATE: 42P13

Description: Only one AS clause is required.

Solution: Check the function definition and ensure that only one AS clause exists.

GAUSS-00954: "language '%s' does not exist"

SQLSTATE: 42704

Description: The language does not exist.

Solution: Check the function definition and ensure that the language type of the function is supported by the database, such as Language PLPGSQL and Language SQL.

GAUSS-00955: "only system admin can define a leakproof function"

SQLSTATE: 42501

Description: Only the system administrator can define the leakproof function.

Solution: Create the leakproof function using the system administrator account.

GAUSS-00956: "function result type must be specified"

SQLSTATE: 42P13

Description: The return type of the function is not specified.

Solution: Specify the return type of the function or the parameter OUT. If no value is returned, use RETURNS void.

GAUSS-00957: "function result type cannot be a view."

SQLSTATE: 42P13

Description: The return type of the function cannot be a view.

Solution: Check the function definition, and do not use a view as the return type of the function.

GAUSS-00958: "ROWS is not applicable when function does not return a set"

SQLSTATE: 22023

Description: If the return value of the function is a result set, do not specify ROWS.

Solution: Check the function definition, and specify ROWS only for the function of which the return value is a result set.

GAUSS-00959: "cache lookup failed for pg_aggregate tuple for function %u"

SQLSTATE: XX000

Description: The required aggregate function is not found in pg_aggregate.

Solution: The system catalog is abnormal. Contact technical support.

GAUSS-00960: "function %u doesn't return OPAQUE"

SQLSTATE: XX000

Description: The return type of the function is not OPAQUE.

Solution: Check whether the returned type of the required function is correct.