Re: Constraint between 2 tables and taking a coherent snapshot of both

Поиск
Список
Период
Сортировка
От decibel
Тема Re: Constraint between 2 tables and taking a coherent snapshot of both
Дата
Msg-id FBC1E0BF-A99D-468A-A015-F284E05F4E36@decibel.org
обсуждение исходный текст
Ответ на Constraint between 2 tables and taking a coherent snapshot of both  (Ivan Sergio Borgonovo <mail@webthatworks.it>)
Список pgsql-general
On Jul 26, 2009, at 1:32 PM, Ivan Sergio Borgonovo wrote:
> Actually a serializable transaction doesn't even seem a too bad
> solution... but I just would like to understand better how to manage
> this situation so that I could make it as simple as possible AND
> lower as much as possible the chances that the transaction will have
> to be rolled back.


This sounds exactly what serialized transactions are for. And I would
certainly promote simplicity over worrying about things like rollback
performance.
--
Decibel!, aka Jim C. Nasby, Database Architect  decibel@decibel.org
Give your computer some brain candy! www.distributed.net Team #1828



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

Предыдущее
От: Jeff Davis
Дата:
Сообщение: Re: Empty Updates, ON UPDATE triggers and Rules
Следующее
От: Jeff Davis
Дата:
Сообщение: Re: Empty Updates, ON UPDATE triggers and Rules