Postgres Pro
Downloads
Home   >   mailing lists

Re: locks in CREATE TRIGGER, ADD FK - Mailing list pgsql-hackers

From Tom Lane
Subject Re: locks in CREATE TRIGGER, ADD FK
Date
Msg-id 6459.1111590283@sss.pgh.pa.us
Whole thread Raw
In response to Re: locks in CREATE TRIGGER, ADD FK  (Neil Conway <neilc@samurai.com>)
Responses Re: locks in CREATE TRIGGER, ADD FK
Re: locks in CREATE TRIGGER, ADD FK
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: strk
Date:
Subject: Re: help with corrupted database
Next
From: Tom Lane
Date:
Subject: Re: locks in CREATE TRIGGER, ADD FK