On Mon, Oct 12, 2015 at 6:28 PM, Sanket Mehta <[email protected] > 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 < > [email protected]> 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 >> > >
