Re: Asynchronous Trigger?

Поиск
Список
Период
Сортировка
От Adam Tauno Williams
Тема Re: Asynchronous Trigger?
Дата
Msg-id 1522404051.3217.1.camel@whitemice.org
обсуждение исходный текст
Ответ на Asynchronous Trigger?  (Cory Tucker <cory.tucker@gmail.com>)
Список pgsql-general
Дерево обсуждения 
On Thu, 2018-03-29 at 22:29 +0000, Cory Tucker wrote:
> Is it possible to have the execution of a trigger (or any function)
> not block the completion of the statement they are associated with?
> A pattern I had hoped to implement was to do a quick update of rows
> that signaled they needed attention, and then an async per-row
> trigger would come and do the maintenance (in this case, make an
> expensive materialized view).

This is a good use of a Notification.  A trigger can queue a
notification, which can be received by a listening process - which can
then determine and do whatever is necessary.

See the "LISTEN" documentation.


-- 
Adam Tauno Williams <mailto:awilliam@whitemice.org> GPG D95ED383
OpenGroupware Developer <http://www.opengroupware.us/>

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