Postgres Pro
Downloads
Home   >   mailing lists

lock in access exclusive and sequence question - Mailing list pgsql-general

From Creager, Robert S
Subject lock in access exclusive and sequence question
Date
Msg-id 10FE17AD5F7ED31188CE002048406DE8514D57@lsv-msg06.stortek.com
Whole thread Raw
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "Joseph"
Date:
Subject: php Compile question
Next
From: Tom Lane
Date:
Subject: Re: "Tuple too big" when the tuple is not that big...