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

From Neil Conway
Subject locks in CREATE TRIGGER, ADD FK
Date
Msg-id 423FB38F.4090002@samurai.com
Whole thread Raw
Responses Re: locks in CREATE TRIGGER, ADD FK
Re: locks in CREATE TRIGGER, ADD FK
List pgsql-hackers
AndrewSN pointed out on IRC that ALTER TABLE ... ADD FOREIGN KEY and 
CREATE TRIGGER both acquire AccessExclusiveLocks on the table they are 
adding triggers to (the PK table, in the case of ALTER TABLE). Is this 
necessary? I don't see why we can't allow SELECT queries on the table to 
proceed while the trigger is being added.

-Neil


pgsql-hackers by date:

Previous
From: Greg Stark
Date:
Subject: Re: Proposal: OUT parameters for plpgsql
Next
From: Neil Conway
Date:
Subject: Re: locks in CREATE TRIGGER, ADD FK