Postgres Pro
Downloads
Home   >   mailing lists

Re: AW: Issue NOTICE for attempt to raise lock level? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: AW: Issue NOTICE for attempt to raise lock level?
Date
Msg-id 14948.973626712@sss.pgh.pa.us
Whole thread Raw
In response to Re: AW: Issue NOTICE for attempt to raise lock level?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
I said:
> CREATE/DROP INDEX grab exclusive lock on the parent table,

Correction: DROP INDEX grabs exclusive lock, CREATE only grabs a
ShareLock on the parent.  But that's OK since addition of an index
doesn't hurt existing readers.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: AW: Issue NOTICE for attempt to raise lock level?
Next
From: Peter Eisentraut
Date:
Subject: Re: Need a debugging tip or two