On 9/6/06, Arturo Perez <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
