Collected from the PG bugs email list.
|OS||Ubuntu 18.04.3 LTS|
|Reported by||Shahzad Ahmad|
Body of first available message related to this bug follows.
The following bug has been logged on the website: Bug reference: 16181 Logged by: Shahzad Ahmad Email address: (redacted) PostgreSQL version: 12.1 Operating system: Ubuntu 18.04.3 LTS Description: I tried both pgAdmin GUI and psql using a script file. In both instances i got the same error. CREATE OR REPLACE PROCEDURE admin.my_test(IN role_id integer DEFAULT 0) LANGUAGE 'plpgsql' AS $BODY$ IF my_test.user_id = 0 THEN Select * from admin.roles order by role_name; ELSE Select * from admin.roles WHERE role_id = my_test.user_id order by role_name; END IF; $BODY$; ERROR: syntax error at or near "IF" LINE 5: IF my_test.user_id = 0 THEN ^ SQL state: 42601 Character: 103
|2020-01-01 23:42:44+00||PG Bug reporting form||BUG #16181: Error Creating Stored Procedures|
|2020-01-02 00:01:32+00||"David G(dot) Johnston"||Re: BUG #16181: Error Creating Stored Procedures|
|2020-01-02 00:18:32+00||"Shahzad Ahmad"||RE: BUG #16181: Error Creating Stored Procedures|