Re: Reindexdb + relation error

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: frant101(at)googlemail(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Reindexdb + relation error
Date: 2008-03-10 20:57:25
Message-ID: 22777.1205182645@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2008-03-10 21:08:28 Re: pg_type.relacl
Previous Message Tom Lane 2008-03-10 20:51:53 Re: php pg_connect fails, pgsql works