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

Поиск
Список
Период
Сортировка
От Ashesh Vashi
Тема Re: PATCH: move object to....(tablespace context)
Дата
Msg-id CAG7mmowW1L8NT3pb5SE3Opf2qKfPfhsk277s1SdSZCnEstdjPg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: PATCH: move object to....(tablespace context)  (Sanket Mehta <sanket.mehta@enterprisedb.com>)
Список pgadmin-hackers
Дерево обсуждения
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


В списке pgadmin-hackers по дате отправления: