From: | frant101(at)googlemail(dot)com |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Reindexdb + relation error |
Date: | 2008-03-11 08:38:03 |
Message-ID: | 41b6877b-2d5f-4cb9-944b-447b8679fdc5@o77g2000hsf.googlegroups.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Mar 10, 8:57 pm, t(dot)(dot)(dot)(at)sss(dot)pgh(dot)pa(dot)us (Tom Lane) wrote:
> frant(dot)(dot)(dot)(at)googlemail(dot)com 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(dot)(dot)(dot)(at)postgresql(dot)org)
> 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
From | Date | Subject | |
---|---|---|---|
Next Message | Luca Ferrari | 2008-03-11 08:54:47 | split pg_dumpall backups per database |
Previous Message | Martijn van Oosterhout | 2008-03-11 08:03:45 | Re: how do you write aggregate function |