lock in access exclusive and sequence question

Поиск
Список
Период
Сортировка
От Creager, Robert S
Тема lock in access exclusive and sequence question
Дата
Msg-id 10FE17AD5F7ED31188CE002048406DE8514D57@lsv-msg06.stortek.com
обсуждение исходный текст
Список 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



В списке pgsql-general по дате отправления:

Предыдущее
От: "Joseph"
Дата:
Сообщение: php Compile question
Следующее
От: Tom Lane
Дата:
Сообщение: Re: "Tuple too big" when the tuple is not that big...