Re: Reducing lock strength of adding foreign keys

On 10/22/2014 04:13 PM, Tom Lane wrote:
> Andreas Karlsson <andreas@proxel.se> writes:
>> I have attached a proof of concept
>> patch which reduces the lock strength to ShareLock.
>
> You're kidding, right?  ShareLock isn't even self-exclusive.

Why would it have to be self-exclusive? As far as I know we only need to 
ensure that nobody changes the rows while we add the trigger. Adding 
multiple triggers concurrently should not pose a problem unless I am 
missing something (which I probably am).

Andreas