Re: Reindex + relation doesnt exist

On Mar 10, 10:43 pm, scott.marl...@gmail.com ("Scott Marlowe") wrote:
> On Mon, Mar 10, 2008 at 8:49 AM,  <frant...@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?
>
> --
> Sent via pgsql-admin mailing list (pgsql-ad...@postgresql.org)
> To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-admin- Hide quoted text -
>
> - Show quoted text -

I have tried to put the schema name in front of the index name put i
still get the same error.

./reindexdb -e --index sc1.ind1 hermes
reindexdb: reindexing of index "sc1.ind1" in database "hermes" failed:
ERROR:  relation "sc1.ind1" does not exist

If i use the command on an index in the public schema it works fine.
Which i guess relates to the search path that you mentioned in your
post...just dont understand why the above command doesnt work.

Thanks
Fran