Re: Reindex + relation doesnt exist - Mailing list pgsql-admin

From Scott Marlowe
Subject Re: Reindex + relation doesnt exist
Date
Msg-id dcc563d10803101543j4223dc9ckfb417bca7a974b35@mail.gmail.com
Whole thread Raw
In response to Reindex + relation doesnt exist  (frant101@googlemail.com)
List pgsql-admin
On Mon, Mar 10, 2008 at 8:49 AM,  <frant101@googlemail.com> wrote:
> I am trying to reindex some indexes through a batch script.  for
>  example
>
>  Database : hermes
>  Schema : sc1
>  Indexes : ind1
>
>  when i use reindexdb with the following switches
>
>   ./reindexdb --index=ind1 hermes
>
>  i get the below error message
>  reindexdb: reindexing of index "ind1" in database "hermes" failed:
>  ERROR:  relation "ind1" does not exist
>
>  when i know that the index does exist, same thing happens if i set up
>  a batch script and call it through psql command using the reindex
>  index ind1;

Is it perhaps in a different schema / search path than the one you're
accessing?  If you append the schema to the name does it work?

pgsql-admin by date:

Previous
From: Grzegorz Dostatni
Date:
Subject: WAL Archiving, warm standby - edge cases questions:
Next
From: Kieran McCusker
Date:
Subject: Perform an action on schema drop