Re: reindexdb -t schema.table name

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

In response to

Responses

Browse pgsql-admin by date

  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