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

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

Вложения

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

Предыдущее
От: Sanket Mehta
Дата:
Сообщение: PATCH: move object to....(tablespace context)
Следующее
От: Ashesh Vashi
Дата:
Сообщение: pgAdmin III commit: Use the correct syntax for moving the objects from