Re: Resetting a sequence's last value...
| От | Bruno Wolff III |
|---|---|
| Тема | Re: Resetting a sequence's last value... |
| Дата | |
| Msg-id | 20030427205216.GA28917@wolff.to обсуждение исходный текст |
| Ответ на | Re: Resetting a sequence's last value... (Sean Chittenden <sean@chittenden.org>) |
| Ответы |
Re: Resetting a sequence's last value...
Re: Resetting a sequence's last value... |
| Список | pgsql-general |
On Sun, Apr 27, 2003 at 12:39:37 -0700,
Sean Chittenden <sean@chittenden.org> wrote:
>
> Thoughts? I got a post offlist suggesting writing a C function, but
> that's pretty dependent on the backend and would have to be recompiled
> from version to version, something I'm not too wild about. -sc
What would seem logical to me is using the iscalled parameter to setval
to determine this. If you call setval('seq', 1, false), I think it
would be reasonable for the currval('seq') to be undefined until
nextval('seq') or setval with iscalled=true is called.
В списке pgsql-general по дате отправления: