Re: Optimization for updating foreign tables in Postgres FDW

Поиск
Список
Период
Сортировка
От Thom Brown
Тема Re: Optimization for updating foreign tables in Postgres FDW
Дата
Msg-id CAA-aLv5dkX0NyFNiGB5SYZ39EscSYEUwQi4uDi5v0gAZ7NC5zQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Optimization for updating foreign tables in Postgres FDW  (Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>)
Ответы Re: Optimization for updating foreign tables in Postgres FDW  (Michael Paquier <michael.paquier@gmail.com>)
Список pgsql-hackers
On 22 March 2016 at 02:30, Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp> wrote:
> On 2016/03/19 3:30, Robert Haas wrote:
>>
>> On Fri, Mar 18, 2016 at 5:15 AM, Etsuro Fujita
>> <fujita.etsuro@lab.ntt.co.jp> wrote:
>>>
>>> Attached is the updated version of the patch.

I've noticed that you now can't cancel a query if there's DML pushdown
to a foreign server.  This previously worked while it was sending
individual statements as it interrupted and rolled it back.

Here's what the local server sees when trying to cancel:

# DELETE FROM remote.contacts;
^CCancel request sent
DELETE 5000000

This should probably be fixed.

Thom



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

Предыдущее
От: Andreas Karlsson
Дата:
Сообщение: Re: [PROPOSAL] Add SCTP network protocol to postgresql backend and frontend
Следующее
От: Merlin Moncure
Дата:
Сообщение: Re: NOT EXIST for PREPARE