Reindexdb + relation error

From: frant101(at)googlemail(dot)com
To: pgsql-general(at)postgresql(dot)org
Subject: Reindexdb + relation error
Date: 2008-03-10 16:04:02
Message-ID: 6d4700d0-7f2a-445c-92e7-2cd33026e208@c33g2000hsd.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dimitri Fontaine 2008-03-10 16:08:08 Re: multi-threaded pgloader needs your tests
Previous Message Kynn Jones 2008-03-10 15:50:26 ISO something like "#if 0 ... #endif" for SQL code