LINE 1: CALL random();

^

HINT: To call a function, use SELECT.

CREATE FUNCTIONtestfunc1(a int) RETURNS int LANGUAGE SQL AS $$ SELECT a $$;

CREATE FUNCTIONcp_testfunc1(a int) RETURNS int LANGUAGE SQL AS $$ SELECT a $$;

CREATE TABLE cp_test (a int, b text);

CREATE PROCEDURE ptest1(x text)

LANGUAGE SQL

^

ALTER FUNCTION ptest1(text) VOLATILE; -- error: not a function

ERROR: ptest1(text) is not a function

ALTER PROCEDUREtestfunc1(int) VOLATILE; -- error: not a procedure

ERROR:testfunc1(integer) is not a procedure

ALTER PROCEDUREcp_testfunc1(int) VOLATILE; -- error: not a procedure

ERROR:cp_testfunc1(integer) is not a procedure

ALTER PROCEDURE nonexistent() VOLATILE;

ERROR: procedure nonexistent() does not exist

DROP FUNCTION ptest1(text); -- error: not a function

ERROR: ptest1(text) is not a function

DROP PROCEDUREtestfunc1(int); -- error: not a procedure

ERROR:testfunc1(integer) is not a procedure

DROP PROCEDUREcp_testfunc1(int); -- error: not a procedure

ERROR:cp_testfunc1(integer) is not a procedure

DROP PROCEDURE nonexistent();

ERROR: procedure nonexistent() does not exist

-- privileges

CALL ptest1('a'); -- ok

RESET ROLE;

-- ROUTINE syntax

ALTER ROUTINEtestfunc1(int) RENAME TOtestfunc1a;

ALTER ROUTINEtestfunc1a RENAME TOtestfunc1;

ALTER ROUTINEcp_testfunc1(int) RENAME TOcp_testfunc1a;

ALTER ROUTINEcp_testfunc1a RENAME TOcp_testfunc1;

ALTER ROUTINE ptest1(text) RENAME TO ptest1a;

ALTER ROUTINE ptest1a RENAME TO ptest1;

DROP ROUTINEtestfunc1(int);

DROP ROUTINEcp_testfunc1(int);

-- cleanup

DROP PROCEDURE ptest1;

DROP PROCEDURE ptest2;