Re: Avoiding deadlocks ...

Поиск
Список
Период
Сортировка
От Marko Tiikkaja
Тема Re: Avoiding deadlocks ...
Дата
Msg-id 4C6E9DDB.9010009@cs.helsinki.fi
обсуждение исходный текст
Ответ на Re: Avoiding deadlocks ...  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Ответы Re: Avoiding deadlocks ...  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-hackers
On 2010-08-20 6:19 PM, Kevin Grittner wrote:
> Marko Tiikkaja<marko.tiikkaja@cs.helsinki.fi>  wrote:
>
>> I think truly serializable transactions still need to SELECT FOR
>> SHARE here for foreign keys to work, no?
>
> That depends on how you look at it.  The SSI patch that Dan and I
> have been working on doesn't attempt to change the implementation
> techniques for foreign keys, because SSI only enforces integrity
> among serializable transactions -- and we want foreign keys to be
> enforced regardless of the transaction isolation levels used.

Exactly.


Regards,
Marko Tiikkaja


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Deadlock bug
Следующее
От: Joel Jacobson
Дата:
Сообщение: Re: Deadlock bug