Re: funny lock mode in DropTrigger - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: funny lock mode in DropTrigger
Date
Msg-id 1319169420-sup-2249@alvh.no-ip.org
Whole thread Raw
Responses Re: funny lock mode in DropTrigger  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Excerpts from Alvaro Herrera's message of vie oct 21 00:40:26 -0300 2011:

> Besides, the docs state that no backend code uses ShareRowExclusiveLock
> anyway (13.3 Explicit locking).  I guess that if the patch to reduce
> lock strength in alter table goes in again, it'll need to update this
> chapter to match.

Ah, I also noticed that the ALTER EXTENSION and SECURITY LABEL commands
use ShareUpdateExclusiveLock, and they failed when committed to note
this in the 13.3 chapter of the docs.  Not sure how strict we are about
documenting these things.  (I note COMMENT already fails to document its
ShareUpdExcl lock).

-- 
Álvaro Herrera <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support


pgsql-hackers by date:

Previous
From: Kohei KaiGai
Date:
Subject: Re: [v9.2] DROP statement reworks
Next
From: Alvaro Herrera
Date:
Subject: funny lock mode in DropTrigger