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

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