[HACKERS] locks in CREATE TRIGGER, ADD FK

[Neil Conway]

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
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
              http://www.postgresql.org/docs/faq