Re: [HACKERS] pg_background contrib module proposal

Поиск
Список
Период
Сортировка
От Craig Ringer
Тема Re: [HACKERS] pg_background contrib module proposal
Дата
Msg-id CAMsr+YG_pY6UJ6C=+H70C7Lh47H1qrDg1WML2xd3eCUwPt2pvg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [HACKERS] pg_background contrib module proposal  (amul sul <sulamul@gmail.com>)
Список pgsql-hackers
Дерево обсуждения
On 13 Dec. 2016 20:54, "amul sul" <sulamul@gmail.com> wrote:


postgres=> select * from pg_background_result(67069) as (x text);
ERROR:  terminating connection due to administrator command
CONTEXT:  background worker, pid 67069
postgres=>

It'll also want to handle cancellation due to conflict with recovery if you intend it to be used on a standby, probably by making use of procsignal_sigusr1_handler. The rest of the work is done by CHECK_FOR_INTERRUPTS() .

This only matters if it's meant to work on standbys of course. I haven't checked if you write to catalogs or otherwise do non-standby-friendly things.

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

Предыдущее
От: Kevin Grittner
Дата:
Сообщение: Re: [HACKERS] [OSSTEST PATCH 0/1] PostgreSQL db: Retry on constraint violation
Следующее
От: Venkata B Nagothi
Дата:
Сообщение: Re: [HACKERS] Declarative partitioning - another take