Postgres Pro
Downloads
Home   >   mailing lists

Re: PATCH: move object to....(tablespace context) - Mailing list pgadmin-hackers

From Sanket Mehta
Subject Re: PATCH: move object to....(tablespace context)
Date
Msg-id CA+yw=mNk=yi5HEdtiPWKY84EKxA6anWHxQ9Fw2LKc0e1b2kvzQ@mail.gmail.com
Whole thread Raw
In response to PATCH: move object to....(tablespace context)  (Sanket Mehta <sanket.mehta@enterprisedb.com>)
Responses Re: PATCH: move object to....(tablespace context)  (Ashesh Vashi <ashesh.vashi@enterprisedb.com>)
List pgadmin-hackers
Tree view
Hi Ashesh,

PFA the updated patch which includes the changes you have suggested.
Please do review and commit it.

Regards,
Sanket Mehta
Sr Software engineer
Enterprisedb

On Mon, Oct 12, 2015 at 4:55 PM, Sanket Mehta <sanket.mehta@enterprisedb.com> wrote:
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

pgadmin-hackers by date:

Previous
From: Sanket Mehta
Date:
Subject: PATCH: move object to....(tablespace context)
Next
From: Ashesh Vashi
Date:
Subject: pgAdmin III commit: Use the correct syntax for moving the objects from