Regarding NOTIFY

From: Bret Stern <bret_stern(at)machinemanagement(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Regarding NOTIFY
Date: 2012-03-09 16:53:25
Message-ID: 1331312006.2133.10.camel@fedora13
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

We have a concrete batching application composed of two parts.
1. The Monitor.
The Monitor cycles every 60 seconds, and looks into a Postgresql table
for jobs to run. Primarily these jobs update Postgresql tables with
data from external applications.

2. The Client.
The client schedules orders etc.

When a new product or customer is added to the Accounting or Batching
Controller (both external applications; and databases) the Client user
clicks a button and adds a job to run on the Monitor.

Is it possible use the NOTIFY event to serve more like an interrupt,
and trigger the Monitor to run immediately.

Can it be used with VB?
or
Should I use LibPQ?

Any suggestions welcome.

If this is the wrong list for these questions, let me know?

Bret Stern

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2012-03-09 17:06:04 Re: Call for Google Summer of Code (GSoC) 2012: Project ideas?
Previous Message Scott Marlowe 2012-03-09 16:22:36 Re: autovacuum and transaction id wraparound