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

From Tom Lane
Subject Re: Reindex + relation doesnt exist
Date
Msg-id 20254.1205248027@sss.pgh.pa.us
Whole thread Raw
In response to Re: Reindex + relation doesnt exist  (frant101@googlemail.com)
List pgsql-admin
frant101@googlemail.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

pgsql-admin by date:

Previous
From: "Milen A. Radev"
Date:
Subject: Re: helpppppppppppppppp??????????
Next
From: Melvin Davidson
Date:
Subject: FILL FACTOR information