PG:not work with procedure

[lalexs75]

PG:not work with procedure

[lalexs75]

CREATE PROCEDURE insert_data(a integer, b integer)
LANGUAGE SQL
AS $$
INSERT INTO tbl VALUES (a);
INSERT INTO tbl VALUES (b);
$$;

CALL insert_data(1, 2);

ALTER PROCEDURE insert_data(integer, integer) RENAME TO insert_record;

ALTER PROCEDURE insert_data(integer, integer) OWNER TO joe;

ALTER PROCEDURE insert_data(integer, integer) SET SCHEMA accounting;

ALTER PROCEDURE insert_data(integer, integer) DEPENDS ON EXTENSION myext;

ALTER PROCEDURE check_password(text) SET search_path = admin, pg_temp;

ALTER PROCEDURE check_password(text) RESET search_path;

DROP PROCEDURE do_db_maintenance();