Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Z3BS3-0003ye-IG for pgsql-docs@arkaria.postgresql.org; Thu, 11 Jun 2015 22:59:59 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1Z3BS2-0000d1-Tt for pgsql-docs@arkaria.postgresql.org; Thu, 11 Jun 2015 22:59:58 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1Z3BS1-0000cq-WA; Thu, 11 Jun 2015 22:59:58 +0000 Received: from [2600:3c02::f03c:91ff:fe70:c491] (helo=apinaye.timbira.com.br) by makus.postgresql.org with esmtp (Exim 4.84) (envelope-from ) id 1Z3BRz-0003Q2-3t; Thu, 11 Jun 2015 22:59:56 +0000 Received: by apinaye.timbira.com.br (Postfix, from userid 110) id 651C61109C; Thu, 11 Jun 2015 19:59:54 -0300 (BRT) X-Spam-Checker-Version: SpamAssassin 3.3.1 (2010-03-16) on apinaye X-Spam-Level: X-Spam-Status: No, score=-100.2 required=5.0 tests=ALL_TRUSTED,BAYES_00, DNS_FROM_AHBL_RHSBL, URIBL_BLOCKED, USER_IN_WHITELIST autolearn=no version=3.3.1 Received: from [10.3.2.2] (unknown [177.203.27.84]) by apinaye.timbira.com.br (Postfix) with ESMTPSA id 417041107D; Thu, 11 Jun 2015 19:59:53 -0300 (BRT) Message-ID: <557A12E6.401@timbira.com.br> Date: Thu, 11 Jun 2015 19:59:50 -0300 From: Euler Taveira Organization: Timbira User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:31.0) Gecko/20100101 Icedove/31.7.0 MIME-Version: 1.0 To: liuyuanyuan , pgsql-admin@postgresql.org, pgsql-docs@postgresql.org Subject: Re: Failed in moving database objects to another tablespace References: <002101d0a3f0$20e40f80$62ac2e80$@gmail.com> In-Reply-To: <002101d0a3f0$20e40f80$62ac2e80$@gmail.com> Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: 7bit X-Host-Lookup-Failed: Reverse DNS lookup failed for 2600:3c02::f03c:91ff:fe70:c491 (failed) X-Pg-Spam-Score: -1.1 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-docs Precedence: bulk Sender: pgsql-docs-owner@postgresql.org 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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs