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.
Last Article: GAUSS-00941 -- GAUSS-00950
Next Article: GAUSS-00961 -- GAUSS-00970
Did this article solve your problem?
Thank you for your score!Your feedback would help us improve the website.