Re: Reindex + relation doesnt exist

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: frant101(at)googlemail(dot)com
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Reindex + relation doesnt exist
Date: 2008-03-11 15:07:07
Message-ID: 20254.1205248027@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Alvaro Herrera 2008-03-11 15:21:24 Re: FILL FACTOR information
Previous Message Melvin Davidson 2008-03-11 15:07:03 FILL FACTOR information