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

On Mon, Oct 12, 2015 at 6:28 PM, Sanket Mehta <sanket(dot)mehta(at)enterprisedb(dot)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.enterprisedb.com>

*http://www.linkedin.com/in/asheshvashi*
<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(dot)mehta(at)enterprisedb(dot)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
>>
>
>