Postgres Pro
Downloads
Home   >   mailing lists

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

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

From
Sanket Mehta
Date:
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

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

From
Sanket Mehta
Date:
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

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

From
Ashesh Vashi
Date:
On Mon, Oct 12, 2015 at 6:28 PM, Sanket Mehta <sanket.mehta@enterprisedb.com> wrote:
Hi Ashesh,

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

Thanks for the patch.
It has been committed.

--

Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company


http://www.linkedin.com/in/asheshvashi

 

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