lock in access exclusive and sequence question
Creager, Robert S <creagrs@louisville.stortek.com>
From: "Creager, Robert S" <CreagRS@LOUISVILLE.STORTEK.COM>
To: "'General - PGSQL'" <pgsql-general@postgresql.org>
Date: 2001-04-04T18:12:34Z
Lists: pgsql-general
I'm creating a script which will re-claim sequence numbers in a table by 'packing' the existing sequence numbers. My questions is if I lock the table in access exclusive mode, and an insert into that table occurs after the lock, with the insert be blocked before or after the nextval is chosen? Thanks, Rob Robert Creager Senior Software Engineer Client Server Library 303.673.2365 V 303.661.5379 F 888.912.4458 P StorageTek INFORMATION made POWERFUL