From: | Sanket Mehta <sanket(dot)mehta(at)enterprisedb(dot)com> |
---|---|
To: | pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org> |
Cc: | Ashesh Vashi <ashesh(dot)vashi(at)enterprisedb(dot)com> |
Subject: | PATCH: move object to....(tablespace context) |
Date: | 2015-10-12 11:25:13 |
Message-ID: | CA+yw=mMq5vuUc+g0Y=KkYrKBkf_xagKYEcCbOzxy+m+AOYpx-Q@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-hackers |
Hi Ashesh,
I have created a patch regarding an issue in pgadmin related to tablespace
context.
*Issue:*
While moving Table/Index/materialized view/All to another tablespace,
pgadmin gives error mentioned below:
ERROR: syntax error at or near "MOVE"
*Reason:*
As mentioned in commit id: 3c4cf080879b386d4ed1814667aca025caafe608
in PostgreSQL database, ALTER TABLESPACE src MOVE dest OWNED BY username
syntax has been changed
*Current implementation in postgreSQL db is as below:*
ALTER TABLE/INDEX/MATERIALIZED VIEW ALL IN TABLESPACE src OWNED BY username
SET TABLESPACE dest
*Changes made:*
Changes made to generate sql as per current implementation in PostgreSQL.
Please do review and commit it.
Regards,
Sanket Mehta
Sr Software engineer
Enterprisedb
Attachment | Content-Type | Size |
---|---|---|
pgadmin_move_object_to_tablespace_context.patch | text/x-patch | 3.4 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Sanket Mehta | 2015-10-12 12:58:00 | Re: PATCH: move object to....(tablespace context) |
Previous Message | Dave Page | 2015-10-12 08:21:28 | Re: Documentation Patch for Auto-Commit Feature (query.rst) |