Philip Warner <pjw(at)rhyme(dot)com(dot)au> writes:
> OK. Given the discussion of 'select nextval', do you know if 'select
> setval' will set the is_called flag?
Looks like it does, both by experiment and by reading the code.
So if you issue a setval() you don't need a nextval() as well.
However you still have the problem that you can't recreate the
state of a virgin (never-nextval'd) sequence this way. The
existing pg_dump code is correct, in that it will reproduce the
state of a sequence whether virgin or not. A data-only reload
would fail to make that guarantee unless you drop and recreate
regards, tom lane
In response to
pgsql-hackers by date
|Next:||From: Tom Lane||Date: 2000-09-28 15:12:25|
|Subject: Re: sys_nerr, sys_errlist |
|Previous:||From: Tom Lane||Date: 2000-09-28 14:36:56|
|Subject: Re: pg_dump and sequences - RFC |