Re: reindexdb -t schema.table name - Mailing list pgsql-admin

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>