| From: | durumdara <durumdara(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Is there any special way to a trigger send a signal to outer application? |
| Date: | 2009-04-02 07:46:40 |
| Message-ID: | 49D46D60.8070201@gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi!
Windows Server, PGSQL.
When a new records arrived to the database, I want process them in the
background.
I have a processor service.
This is periodically (5-10 minutes) checking the "message" table, and if
there is some message, it is process them.
This periodic processing is good, but I want to decrease the process
time, when records arrived (to increase the performance, and dec. the
user's waiting).
So I search for a way to do any IPC communication from PGSQL to the
processor service.
Which way is supports by PGSQL trigger?
a.) Starting a new process with any params (this app. can send a WM_*
message to my service)?
b.) Sending a WM_* message (PostMessage) to my service?
c.) Sending a TCP message to my service?
Or other?
If you have an example about this problem, please send me with the answer!
Thanks for your help:
dd
| From | Date | Subject | |
|---|---|---|---|
| Next Message | linnewbie | 2009-04-02 08:20:00 | Posgres Adding braces at beginning and end of text (html) content |
| Previous Message | Tino Wildenhain | 2009-04-02 06:22:32 | Re: [GENERAL] string_to_array with empty input |