Re: how to write/setup a C trigger function in a background worker

Поиск
Список
Период
Сортировка
От David Fetter
Тема Re: how to write/setup a C trigger function in a background worker
Дата
Msg-id 20150819170155.GC16249@fetter.org
обсуждение исходный текст
Ответ на how to write/setup a C trigger function in a background worker  (jacques klein <jacques.klei@googlemail.com>)
Ответы Re: how to write/setup a C trigger function in a background worker  (jacques klein <jacques.klei@googlemail.com>)
Список pgsql-hackers
On Wed, Aug 19, 2015 at 05:37:31PM +0200, jacques klein wrote:
> I would like to execute a trigger function (written in C) in one of my
> background workers.
> 
> Didn't figure out how to do that not even if it's possible.

You can write your trigger function in such a way as not to do the
usual check for trigger context, but it might be better to write two
functions, one with the trigger stuff in it, the other, which it
calls, for whatever action you actually want to trigger, and call that
second in your background worker.

Cheers,
David.
-- 
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@gmail.com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Badly broken logic in plpython composite-type handling
Следующее
От: Qingqing Zhou
Дата:
Сообщение: Re: Our trial to TPC-DS but optimizer made unreasonable plan