Re: [DOCS] Failed in moving database objects to another tablespace

2015-06-11 Thread JasmineLiu
Euler Taveira wrote > 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

Re: [DOCS] Failed in moving database objects to another tablespace

2015-06-11 Thread Euler Taveira
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