subject:"\[PATCHES\] CREATE TRIGGER locking"

Re: [PATCHES] CREATE TRIGGER locking

2006-07-04 Thread Tom Lane

Neil Conway <[EMAIL PROTECTED]> writes: > Last year, I questioned why CREATE TRIGGER acquires an > AccessExclusiveLock on its target table: > http://archives.postgresql.org/pgsql-hackers/2005-03/msg00764.php > Acquiring an ExclusiveLock should be sufficient: we can safely allow > concurrent SEL

[PATCHES] CREATE TRIGGER locking

2006-07-03 Thread Neil Conway

Last year, I questioned why CREATE TRIGGER acquires an AccessExclusiveLock on its target table: http://archives.postgresql.org/pgsql-hackers/2005-03/msg00764.php Acquiring an ExclusiveLock should be sufficient: we can safely allow concurrent SELECTs on the table. (The -hackers thread discusse