On Mar 10, 8:57 pm, t...@xxxxxxxxxxxxx (Tom Lane) wrote: > frant...@xxxxxxxxxxxxxx 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 (pgsql-gene...@xxxxxxxxxxxxxx) > 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
