Andy Shellam <andy-lists@xxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
