Re: Problems with sequences

On 9/6/06, Arturo Perez <aperez@hayesinc.com> wrote:
> What happens is that if I do a select nextval('seq') I get a number
> that's lower than the
> max primary key id.  This is inspite of my doing
>    SELECT setval('seq', ((SELECT MAX(seq_ID) FROM table)+1))
>    ALTER SEQUENCE seq RESTART WITH <max + 1>;
>    select pg_catalog.setval(seq, <max+1>, true);
>

are you running those statements to fetch the next key in the table?
you might have a race condition there.  try wrappnig in a userlock.

merlin