PATCH: move object to....(tablespace context)

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: Whole Thread | Raw Message | 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

Responses

Browse pgadmin-hackers by date

  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)