From: | "liuyuanyuan" <liuyuanyuangogo(at)gmail(dot)com> |
---|---|
To: | <pgsql-admin(at)postgresql(dot)org>, <pgsql-docs(at)postgresql(dot)org> |
Subject: | Failed in moving database objects to another tablespace |
Date: | 2015-06-11 02:41:06 |
Message-ID: | 002101d0a3f0$20e40f80$62ac2e80$@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-docs |
Hi !
I installed my postgresql and pgadmin III with an windows 32bit installer.
My environment:
Windows7 64bit
Postgresql 9.4.0
Pgadmin III 1.20.0
Then I found the new function in pgadmin III : move database objects to
another tablespace.
First, I tried to execute this function and failed, just as follow (PS: the
ok and cancle button cannot display well, please check):
Then, I tried to execute an sql command like this:
ALTER TABLESPACE pg_default MOVE TABLES OWNED BY yy TO "table";
And I still got an error:
ERROR: syntax error at or near "MOVE"
LINE 1: ALTER tablespace pg_default MOVE TABLES OWNED BY yy TO "tabl...
^
Then I ckeck the Postgresql Document of www.postgresql.org , and I couldn't
find the Syntaxs: ALTER TABLESPACE . MOVE.
So I have to report this problem. Hope to get some reply!
Thanks and Regards!
Liu Yuanyuan
Blog: http://my.oschina.net/liuyuanyuangogo
From | Date | Subject | |
---|---|---|---|
Next Message | hydra | 2015-06-11 05:12:36 | Re: replication consistency checking |
Previous Message | Tom Lane | 2015-06-10 19:20:19 | Re: SQL State 42P01 |
From | Date | Subject | |
---|---|---|---|
Next Message | Fujii Masao | 2015-06-11 16:47:44 | pg_file_settings and catalog.sgml |
Previous Message | Tom Lane | 2015-06-07 21:37:21 | Re: What is the meaning of the N string operator ? |