Re: [SQL] Atomic query and update of sequence generators

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1

Re: [SQL] Atomic query and update of sequence generators

Jeffrey Tenny <[EMAIL PROTECTED]> writes: > If I want to allocate a block of adjacent values from a sequence generator, > is the following statement atomic with respect to the time between > when the call to nextval() and setval()? > SELECT setval('foo', nextval()+20) ... Nope. > The goal is to