On Mar 10, 8:57 pm, [EMAIL PROTECTED] (Tom Lane) wrote: > [EMAIL PROTECTED] 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 > > -- > Sent via pgsql-general mailing list ([EMAIL PROTECTED]) > To make changes to your > subscription:http://www.postgresql.org/mailpref/pgsql-general
I have tried to put the schema name in front of the index name put i still get the same error. ./reindexdb -e --index sc1.ind1 hermes reindexdb: reindexing of index "sc1.ind1" in database "hermes" failed: ERROR: relation "sc1.ind1" does not exist If i use the command on an index in the public schema it works fine. Which i guess relates to the search path that you mentioned in your post...just dont understand why the above command doesnt work. Thanks Fran -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general