On 2010-08-20 6:19 PM, Kevin Grittner wrote:
Marko Tiikkaja<[email protected]> 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
--
Sent via pgsql-hackers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
