Обсуждение: Reindexdb + relation error

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;


I guess i'm missing something really obvious just need someone to
point it out to me !! Any help is much apprciated
Thanks
Fran

frant101@googlemail.com writes:
> 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

Perhaps this is not using the same schema search path that you have
established in your psql environment?

            regards, tom lane

On Mar 10, 8:57 pm, t...@sss.pgh.pa.us (Tom Lane) wrote:
> frant...@googlemail.com writes:
> > 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
>
> Perhaps this is not using the same schema search path that you have
> established in your psql environment?
>
>                         regards, tom lane
>
> --
> Sent via pgsql-general mailing list (pgsql-gene...@postgresql.org)
> To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-general

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