Re: reindexdb -t schema.table name

Поиск
Список
Период
Сортировка
От Andy Shellam
Тема Re: reindexdb -t schema.table name
Дата
Msg-id 4A2EC633.8010402@networkmail.eu
обсуждение исходный текст
Ответ на Re: reindexdb -t schema.table name  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: reindexdb -t schema.table name  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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

В списке pgsql-admin по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: reindexdb -t schema.table name
Следующее
От: Tom Lane
Дата:
Сообщение: Re: reindexdb -t schema.table name