Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Re: Reindex + relation doesnt exist



On Mon, Mar 10, 2008 at 8:49 AM,  <frant101(at)googlemail(dot)com> wrote:
> 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;

Is it perhaps in a different schema / search path than the one you're
accessing?  If you append the schema to the name does it work?



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group