Re: locking of referenced table during constraint - Mailing list pgsql-hackers

From Tom Lane
Subject Re: locking of referenced table during constraint
Date
Msg-id 26131.1031201396@sss.pgh.pa.us
Whole thread Raw
In response to Re: locking of referenced table during constraint  (Scott Shattuck <ss@technicalpursuit.com>)
Responses Re: locking of referenced table during constraint  (Scott Shattuck <ss@technicalpursuit.com>)
List pgsql-hackers
Scott Shattuck <ss@technicalpursuit.com> writes:
> ... I don't understand why an exclusive table-level lock is being
> taken out to add a trigger.

Well, that's a schema change; it makes sense to me to forbid access
while we're changing a table's schema.

I think this discussion may just be a miscommunication: it's not clear
to me whether you're complaining about adding a trigger or just firing
a trigger.  The former is not a time-critical task in my book ...
        regards, tom lane


pgsql-hackers by date:

Previous
From: Scott Shattuck
Date:
Subject: Re: locking of referenced table during constraint
Next
From: Bruce Momjian
Date:
Subject: TODO item on triggers