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 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 > > > -- > Sent via pgsql-docs mailing list (
> pgsql-docs@ > ) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-docs Thanks for your replay! That's all about my pgadmin, please check! <http://postgresql.nabble.com/file/n5853510/QQ%E6%88%AA%E5%9B%BE20150611101253.jpg> Regards! Liu Yuanyuan -- View this message in context: http://postgresql.nabble.com/Failed-in-moving-database-objects-to-another-tablespace-tp5853305p5853510.html Sent from the PostgreSQL - docs mailing list archive at Nabble.com. -- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs
