| From: | Euler Taveira <euler(at)timbira(dot)com(dot)br> |
|---|---|
| To: | liuyuanyuan <liuyuanyuangogo(at)gmail(dot)com>, pgsql-admin(at)postgresql(dot)org, pgsql-docs(at)postgresql(dot)org |
| Subject: | Re: Failed in moving database objects to another tablespace |
| Date: | 2015-06-11 22:59:50 |
| Message-ID: | 557A12E6.401@timbira.com.br |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-docs |
On 10-06-2015 23:41, liuyuanyuan wrote:
> Then, I tried to execute an sql command like this:
>
> ALTER TABLESPACE pg_default MOVE TABLES OWNED BY yy TO "table";
>
This syntax was changed _before_ 9.4 release. The new syntax is:
ALTER TABLE ALL IN TABLESPACE foo SET TABLESPACE bar;
The problem is in pgAdmin. I bet you're running a pgAdmin beta version
or something like that. Could you confirm the exact pgAdmin version?
--
Euler Taveira Timbira - http://www.timbira.com.br/
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento
| From | Date | Subject | |
|---|---|---|---|
| Next Message | JasmineLiu | 2015-06-12 01:26:39 | Re: Failed in moving database objects to another tablespace |
| Previous Message | Bruce Momjian | 2015-06-11 12:53:16 | Re: replication consistency checking |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | JasmineLiu | 2015-06-12 01:26:39 | Re: Failed in moving database objects to another tablespace |
| Previous Message | Fujii Masao | 2015-06-11 16:47:44 | pg_file_settings and catalog.sgml |