Re: Reducing lock strength of adding foreign keys

There are actually TWO tables involved: the table upon which 
the trigger will actually fire, and some other table which is 
mentioned in passing in the trigger definition.  It's possible that 
the locking requirements for the secondary table are weaker since I 
don't think the presence of the trigger actually affects runtime 
behavior there.  However, there's probably little point in try to 
weaken the lock to less than the level required for the main table 
because a foreign key involves adding referential integrity triggers 
to both tables. 




-----
GUL
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Reducing-lock-strength-of-adding-foreign-keys-tp5823894p5824376.html
Sent from the PostgreSQL - hackers mailing list archive at Nabble.com.