Re: locks in CREATE TRIGGER, ADD FK

Neil Conway <neilc@samurai.com> writes:
> Tom Lane wrote:
>> I don't think this has been adequately thought through at all ... but
>> at least make it ExclusiveLock.  What is the use-case for allowing
>> SELECT FOR UPDATE in parallel with this?

> Ok, patch applied -- I adjusted it to use ExclusiveLock, and fleshed out 
> some of the comments.

I think last night's discussion makes it crystal-clear why I felt that
this hasn't been sufficiently thought through.  Please revert until the
discussion comes to a conclusion.
        regards, tom lane