Postgres Pro
Downloads
Home   >   mailing lists

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

From Sanket Mehta
Subject PATCH: move object to....(tablespace context)
Date
Msg-id CA+yw=mMq5vuUc+g0Y=KkYrKBkf_xagKYEcCbOzxy+m+AOYpx-Q@mail.gmail.com
Whole thread Raw
Responses Re: PATCH: move object to....(tablespace context)  (Sanket Mehta <sanket.mehta@enterprisedb.com>)
List pgadmin-hackers
Tree view
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: Dave Page
Date:
Subject: Re: Documentation Patch for Auto-Commit Feature (query.rst)
Next
From: Sanket Mehta
Date:
Subject: Re: PATCH: move object to....(tablespace context)