CREATE TRIGGER locking - Mailing list pgsql-patches

From Neil Conway
Subject CREATE TRIGGER locking
Date
Msg-id 1151994207.5039.18.camel@localhost
Whole thread Raw
Responses Re: CREATE TRIGGER locking
List pgsql-patches
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 discusses both
CREATE TRIGGER and ALTER TABLE ADD FK; the latter might require some
more consideration, so I'll tackle that later.)

This patch implements this change, and updates the documentation.

Barring any objections, I'll apply this in a day or two.

-Neil


Attachment

pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: ADD/DROPS INHERIT (actually INHERIT / NO INHERIT)
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] PQescapeIdentifier