On Mon, 2012-04-09 at 09:03 +0000, Jasen Betts wrote: > On 2012-03-09, Bret Stern <bret_stern@xxxxxxxxxxxxxxxxxxxxx> wrote: > > 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. > > Reasonably immediately. > > > Can it be used with VB? or Should I use LibPQ? > > I used libpq with VB6 when I needed this feature 3 years ago. > > I had to write a little DLL to wrap the libpq calls so that VB could > call them (actually I repackaged the wrapper that the main application uses) > > > If this is the wrong list for these questions, let me know? > > what language are you really using? VB is kind of vague it could mean > .net (lots of people say VB when they mean .net, makes it hard to get > questions about VB answered) > Was referring VB6 (I still prefer the IDE), but I can write in most languages; (codeblocks for the libpq project). > -- > ⚂⚃ 100% natural > > Thanks for the comments. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general