On Tue, May 19, 2009 at 03:32:16PM +0200, Thomas Guettler wrote: > If other processes run nextval() between "increment by 1000" and "increment > by 1", > they leave big holes in the sequence.
yes. I know. there is no other way. if you want 1000 ids, but they don't have to be consequtive, you can simply: select nextval('qq') from generate_series(1,1000); depesz -- Linkedin: http://www.linkedin.com/in/depesz / blog: http://www.depesz.com/ jid/gtalk: dep...@depesz.com / aim:depeszhdl / skype:depesz_hdl / gg:6749007 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general