Re: referential Integrity and SHARE locks - Mailing list pgsql-hackers

From Tom Lane
Subject Re: referential Integrity and SHARE locks
Date
Msg-id 26873.1170813214@sss.pgh.pa.us
Whole thread Raw
In response to Re: referential Integrity and SHARE locks  (Marc Munro <marc@bloodnok.com>)
List pgsql-hackers
Marc Munro <marc@bloodnok.com> writes:
> The RI triggers currently fire when a record is updated.  Under my
> proposal they would fire in the same way but before the record is locked
> rather than after.  Or am I missing your point?

IOW, some other transaction could update or delete the tuple meanwhile?
Doesn't seem very promising.
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Luke Lonergan"
Date:
Subject: Re: doxygen.postgresql.org
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Proposal: TABLE functions