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-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
