Reindex + relation doesnt exist

From: frant101(at)googlemail(dot)com
To: pgsql-admin(at)postgresql(dot)org
Subject: Reindex + relation doesnt exist
Date: 2008-03-10 15:49:30
Message-ID: 54da9d7c-f6c9-41cd-a167-11a52d35b383@x30g2000hsd.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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-admin by date

  From Date Subject
Next Message Peter Koczan 2008-03-10 18:58:17 Re: Newly converted to 8.2.5 and getting this error
Previous Message Tom Lane 2008-03-10 14:49:54 Re: problem with pg_statistic_relid_att_index