Protect a table against concurrent data changes while allowing to vacuum it

Поиск
Список
Период
Сортировка
От Vlad Arkhipov
Тема Protect a table against concurrent data changes while allowing to vacuum it
Дата
Msg-id 576A55EC.3060403@dc.baikal.ru
обсуждение исходный текст
Ответы Re: Protect a table against concurrent data changes while allowing to vacuum it  (Sameer Kumar <sameer.kumar@ashnik.com>)
Re: Protect a table against concurrent data changes while allowing to vacuum it  (Albe Laurenz <laurenz.albe@wien.gv.at>)
Список pgsql-general
Дерево обсуждения 
Hello,

I have a constraint that requires a table to be locked before checking
it (i.e. no more than 2 records with the same value in the same column).
If I lock the table in the SHARE ROW EXCLUSIVE mode, any vacuuming (or
autovacuuming) process prevents me from checking the constraint. What
are possible solutions?

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

Предыдущее
От: Erik Gustafson
Дата:
Сообщение: Re: optimizing a query
Следующее
От: Sameer Kumar
Дата:
Сообщение: Re: Protect a table against concurrent data changes while allowing to vacuum it