lock in access exclusive and sequence question

From: "Creager, Robert S" <CreagRS(at)LOUISVILLE(dot)STORTEK(dot)COM>
To: "'General - PGSQL'" <pgsql-general(at)postgresql(dot)org>
Subject: lock in access exclusive and sequence question
Date: 2001-04-04 18:12:34
Message-ID: 10FE17AD5F7ED31188CE002048406DE8514D57@lsv-msg06.stortek.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-04-04 18:15:16 Re: Postgres 7.1RC1 on Solaris 7
Previous Message jkakar 2001-04-04 17:57:38 Need to do an ALTER TABLE.