From: | Andy Shellam <andy-lists(at)networkmail(dot)eu> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | dx k9 <bitsandbytes88(at)hotmail(dot)com>, posgres support <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: reindexdb -t schema.table name |
Date: | 2009-06-09 20:29:39 |
Message-ID: | 4A2EC633.8010402@networkmail.eu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2009-06-09 20:39:54 | Re: reindexdb -t schema.table name |
Previous Message | Tom Lane | 2009-06-09 19:56:56 | Re: reindexdb -t schema.table name |