Re: Reindex + relation doesnt exist

[Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>]

frant101(at)googlemail(dot)com writes:
> 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

AFAICS reindexdb won't allow that --- it quotes the name you supply,
so that's going to look like a table name that happens to contain a
dot, not a schema and table name.

You didn't say where you are inserting the non-default schema path
into your interactive sessions...

			regards, tom lane