Alter index .. set tablespace uses ACCESS EXCLUSIVE lock?

From: Francisco Reyes <lists(at)stringsutils(dot)com>
To: PostgreSQL general <pgsql-general(at)postgresql(dot)org>
Subject: Alter index .. set tablespace uses ACCESS EXCLUSIVE lock?
Date: 2010-02-11 23:30:40
Message-ID: cone.1265931040.585490.24981.1000@shelca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

The alter index page does not show the lock mode, but it seems it is an
ACCESS EXCLUSIVE.

Wouldn't an EXCLUSIVE lock be more appropriate and remove the index from
planner consideration?

Browse pgsql-general by date

  From Date Subject
Next Message David Kerr 2010-02-12 00:17:30 Re: Deadlock Detected
Previous Message Alvaro Herrera 2010-02-11 23:30:13 Re: Truncate and delete adds wal logs for slave to process.