Re: BUG #16181: Error Creating Stored Procedures

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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-bugs

On Wed, Jan 1, 2020 at 4:43 PM PG Bug reporting form <noreply(at)postgresql(dot)org>

> 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

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

David J.

In response to


Browse pgsql-bugs by date

  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