On Mon, Mar 10, 2008 at 8:49 AM, <[EMAIL PROTECTED]> 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? -- Sent via pgsql-admin mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
