Bruce Momjian <[EMAIL PROTECTED]> writes:
> I was thinking of adding to TODO:
>       * Allow shared row locks for referential integrity
> but how is that different from:
>       * Implement dirty reads and use them in RI triggers

It'd be a completely different approach to solving the FK locking
problem.  I wouldn't think we'd do both.

Personally I'd feel more comfortable with a shared-lock approach, if we
could work out the scalability issues.  Dirty reads seem ... well ...
dirty.

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faqs/FAQ.html

Reply via email to