Hi,
I've also replicated DjK's issue using a table called "supplier" in my
"system" schema.
# andyshel bin (networkmail): ./reindexdb -h localhost -d mydb -t
"system.supplier"
reindexdb: reindexing of table "system.supplier" in database "mydb "
failed: ERROR: relation "system.supplier" does not exist
reindexdb: reindexing of database "mydb " failed: ERROR: relation
"system.supplier" does not exist
After passing the "-e" argument it appears reindexdb is running the
following SQL: REINDEX TABLE "system.supplier";
According to the documentation for 8.3.7 (the version I'm running) this
syntax should work:
Name
REINDEX— rebuild indexes
Synopsis
REINDEX { INDEX | TABLE | DATABASE | SYSTEM } name [ FORCE ]
.....
name
... Index and table names can be schema-qualified ...
Any ideas?
Thanks,
Andy
dx k9 wrote:
Hi all,
I'm having trouble reindexing a table in a schema other than public,
called history.
This syntax isn't working.
reindexdb -h fido -p 5432 -d abc -t history._name_history
reindexdb: reindexing of table "history._name_history" in database
"abc" failed: ERROR:
relation"h
istory._name_history" does not exist
I also tried it with double quotes. -t "history._name_history. The
table is actually _name_history.
Thanks in advance,
~DjK
------------------------------------------------------------------------
Windows Live™ SkyDrive™: Get 25 GB of free online storage. Get it on
your BlackBerry or iPhone.
<http://windowslive.com/online/skydrive?ocid=TXT_TAGLM_WL_SD_25GB_062009>
--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
