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
|
Список | 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 по дате отправления: