Postgres Pro
Downloads
Home   >   mailing lists

Re: REINDEX syntax? - Mailing list pgsql-general

From Tom Lane
Subject Re: REINDEX syntax?
Date
Msg-id 6497.1046702771@sss.pgh.pa.us
Whole thread Raw
In response to REINDEX syntax?  (Jean-Christian Imbeault <jc@mega-bucks.co.jp>)
List pgsql-general
Tree view 
Jean-Christian Imbeault <jc@mega-bucks.co.jp> writes:
> [postgres@localhost pgsql]$ postgres -D /usr/local/pgsql/data -O -P TAL
> backend> Reindex database TAL force;
> ERROR:  REINDEX DATABASE: Can be executed only on the currently open

I think you need
    Reindex database "TAL" force;

            regards, tom lane

pgsql-general by date:

Previous
From: "Sebastiano Cascione"
Date:
Subject: pg_dump version
Next
From: "Marc G. Fournier"
Date:
Subject: Re: Off topic - was Re: [PATCHES] ALTER SEQUENCE