Postgres Pro
Downloads
Home   >   mailing lists

Re: Odd behavior with 'currval' - Mailing list pgsql-general

From Steven Hirsch
Subject Re: Odd behavior with 'currval'
Date
Msg-id alpine.DEB.2.20.1802081620300.5809@z87
Whole thread Raw
In response to Re: Odd behavior with 'currval'  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: Odd behavior with 'currval'
List pgsql-general
Tree view 
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.



--

pgsql-general by date:

Previous
From: Igor Korot
Date:
Subject: Re: DOW is 0-based?
Next
From: "David G. Johnston"
Date:
Subject: Re: Odd behavior with 'currval'