Postgres Pro
Downloads
Home   >   mailing lists

Re: Reducing lock strength of adding foreign keys - Mailing list pgsql-hackers

From Andreas Karlsson
Subject Re: Reducing lock strength of adding foreign keys
Date
Msg-id 5448AD51.6090102@proxel.se
Whole thread Raw
In response to Re: Reducing lock strength of adding foreign keys  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: [PATCH] add ssl_protocols configuration option
Next
From: Dag-Erling Smørgrav
Date:
Subject: Re: [PATCH] add ssl_protocols configuration option