Starting a daemon process on INSERT

Поиск
Список
Период
Сортировка
От P.V. Subramanian
Тема Starting a daemon process on INSERT
Дата
Msg-id F260uYDlrjbudzxxfYX000096ec@hotmail.com
обсуждение исходный текст
Ответы using the Text::Query perl module with postgresql  (harrold@sage.che.pitt.edu)
Список pgsql-novice
Hi all

I am writing an application which needs a daemon process to do some activity
as soon as certain types of records are added.

I don't want the daemon to continuously poll the DB, so I am trying to
create a trigger which would send some kind of signal to this daemon (or
even start a normal executable which terminates after finishing its job).

However I don't seem to be able to accomplish anything trigger driver driven
that would launch another external app. elog notices, SQL queries etc. work
but I want none of these!

Help appreciated.

PVS

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp


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

Предыдущее
От: John Burski
Дата:
Сообщение: Re: Opaque data type
Следующее
От: travep
Дата:
Сообщение: Queries seem to lock up shell session