Re: deadlock in REINDEX

From: Olleg Samoylov <olleg(at)jane(dot)telecom(dot)mipt(dot)ru>
To: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: deadlock in REINDEX
Date: 2003-02-18 14:07:03
Message-ID: Pine.LNX.4.33.0302181704550.19296-100000@jane.telecom.mipt.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, 18 Feb 2003, Gavin Sherry wrote:

GS>Perhaps the change that needs to be made is:
GS>
GS>if(IsUnderPostmaster)
GS> elog(ERROR,"You cannot run REINDEX INDEX in multi-user mode");
GS>
GS>to ReindexIndex() or some other appropriate place (with a better error
GS>message).
GS>
GS>Gavin

It is incorrect. In PostgreSQL REINDEX must be routing (PostgreSQL 7.3.1
Documentation 8.3. Routine Reindexing).

--
Olleg Samoylov

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2003-02-18 14:43:38 Re: Non-colliding auto generated names
Previous Message Bruno Wolff III 2003-02-18 13:46:06 Re: pg environment? metadata?