Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #16181: Error Creating Stored Procedures - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: BUG #16181: Error Creating Stored Procedures
Date
Msg-id CAKFQuwYeco+sqTV4qpFob7egVUFe3nqSPZdbx_+GS=L0jRianQ@mail.gmail.com
Whole thread Raw
In response to BUG #16181: Error Creating Stored Procedures  (PG Bug reporting form <noreply@postgresql.org>)
Responses RE: BUG #16181: Error Creating Stored Procedures  ("Shahzad Ahmad" <shahzadahmad00@gmail.com>)
List pgsql-bugs
Tree view
On Wed, Jan 1, 2020 at 4:43 PM PG Bug reporting form <noreply@postgresql.org> wrote:
The following bug has been logged on the website:

Bug reference:      16181
Logged by:          Shahzad Ahmad
Email address:      shahzadahmad00@gmail.com
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'

Not a bug...the documentation shows how to write a pl/pgsql function/stored procedure.

https://www.postgresql.org/docs/12/plpgsql-structure.html

Note the "BEGIN" and "END" portions of that syntax diagram are not optional.

David J.

pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #16181: Error Creating Stored Procedures
Next
From: "Shahzad Ahmad"
Date:
Subject: RE: BUG #16181: Error Creating Stored Procedures