Re: AW: Issue NOTICE for attempt to raise lock level?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Mikheev, Vadim" <vmikheev(at)SECTORBASE(dot)COM>, Zeugswetter Andreas SB <ZeugswetterA(at)wien(dot)spardat(dot)at>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: AW: Issue NOTICE for attempt to raise lock level?
Date: 2000-11-07 19:51:52
Message-ID: 14948.973626712@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2000-11-07 20:08:20 Re: Need a debugging tip or two
Previous Message Tom Lane 2000-11-07 19:41:09 Re: AW: Issue NOTICE for attempt to raise lock level?