| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | shahzadahmad00(at)gmail(dot)com, PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: BUG #16181: Error Creating Stored Procedures |
| Date: | 2020-01-02 00:01:32 |
| Message-ID: | CAKFQuwYeco+sqTV4qpFob7egVUFe3nqSPZdbx_+GS=L0jRianQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Wed, Jan 1, 2020 at 4:43 PM PG Bug reporting form <noreply(at)postgresql(dot)org>
wrote:
> The following bug has been logged on the website:
>
> Bug reference: 16181
> Logged by: Shahzad Ahmad
> Email address: shahzadahmad00(at)gmail(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shahzad Ahmad | 2020-01-02 00:18:32 | RE: BUG #16181: Error Creating Stored Procedures |
| Previous Message | PG Bug reporting form | 2020-01-01 23:42:44 | BUG #16181: Error Creating Stored Procedures |