On Thu, Feb 8, 2018 at 2:22 PM, Steven Hirsch <snhirsch@gmail.com> wrote:
On Thu, 8 Feb 2018, David G. Johnston wrote:
On Thu, Feb 8, 2018 at 12:54 PM, David G. Johnston <david.g.johnston@gmail.com> wrote: The only 'currval' procedure is the one defined at installation (in public).
So, the installed version of currval would be defined in "pg_catalog", not "public" ...
??
All I can tell you is that when I connect from dbVisualizer and open the twisty under 'main.procedures' I see 100+ functions that are intrinsic to pgsql - currval() included. I have almost no experience writing pgsql procs and absolutely never installed anything that would override the base function.
Just to be certain, what does "\dfS+ currval" output in psql?
I'll agree this would be highly unusual but I so would this being a bug. And the oddity with the lost sequence ownership...