Hi Tom
No. What would work is REINDEX TABLE "system"."supplier";
Ah, thanks for pointing that out, I never clicked on the quoting of the
table name.
reindexdb isn't designed to support schema-qualified names. You'd
need another switch to pass the schema name.
Could it be an option that if the table name is already qualified and
quoted, reindexdb doesn't touch it?
e.g.
# ./reindexdb -h localhost -d mydb -t "system"."supplier" -e
REINDEX TABLE "system.supplier";
would become:
# ./reindexdb -h localhost -d mydb -t "system"."supplier" -e
REINDEX TABLE "system"."supplier";
but:
# ./reindexdb -h localhost -d mydb -t system.supplier -e
REINDEX TABLE "system.supplier";
would still remain the same because it wasn't correctly quoted.
Note: this doesn't actually affect me, and there are other options as
you pointed out, I'm just asking the question :-)
Thanks,
Andy
--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
