2018-03-20 15:18 GMT+01:00 Merlin Moncure <mmonc...@gmail.com>: > On Tue, Mar 20, 2018 at 9:09 AM, Pavel Stehule <pavel.steh...@gmail.com> > wrote: > >> Edit: In one case, after dropping the function and recreating it, I > >> got the procedure to return 0 where it had not before, so this smells > >> like a bug. > >> postgres=# call p(); > >> 2018-03-20 09:04:50.543 CDT [21494] ERROR: function p() does not > >> exist at character 6 > >> 2018-03-20 09:04:50.543 CDT [21494] HINT: No function matches the > >> given name and argument types. You might need to add explicit type > >> casts. > >> 2018-03-20 09:04:50.543 CDT [21494] STATEMENT: call p(); > >> ERROR: function p() does not exist > >> LINE 1: call p(); > >> ^ > >> HINT: No function matches the given name and argument types. You > >> might need to add explicit type casts. > >> Time: 0.297 ms > >> postgres=# create or replace procedure p(a inout int default 7) as $$ > >> begin return; end; $$ language plpgsql; > >> CREATE PROCEDURE > >> Time: 1.182 ms > >> postgres=# call p(); > >> a > >> ─── > >> 0 > >> (1 row) > > > > > > I wrote patch > > Confirmed this fixes the issue. >
Thanks for info Pavel > > merlin >
