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
Re: Protect a table against concurrent data changes while allowing to vacuum it
Список 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 по дате отправления: