Re: Odd behavior with 'currval'
| От | David G. Johnston |
|---|---|
| Тема | Re: Odd behavior with 'currval' |
| Дата | |
| Msg-id | CAKFQuwaLWdEp64f0RWZbM-F-fzzE_Qe3mMXH_s7THJ=TR1A9iA@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Odd behavior with 'currval' (Steven Hirsch <snhirsch@gmail.com>) |
| Ответы |
Re: Odd behavior with 'currval'
|
| Список | pgsql-general |
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...
David J.
В списке pgsql-general по дате отправления: