Andy Shellam <andy-li...@networkmail.eu> writes:
> 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:
No. What would work is REINDEX TABLE "system"."supplier";
reindexdb isn't designed to support schema-qualified names. You'd
need another switch to pass the schema name.
A possible workaround if you really need the schema qualification is
PGOPTIONS="--search_path=system" reindexdb ... -t supplier
regards, tom lane
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
