Re: Regarding NOTIFY - Mailing list pgsql-general

From Bret Stern
Subject Re: Regarding NOTIFY
Date
Msg-id 1333982126.15783.3.camel@fedora13
Whole thread Raw
In response to Re: Regarding NOTIFY  (Jasen Betts <jasen@xnet.co.nz>)
List pgsql-general
On Mon, 2012-04-09 at 09:03 +0000, Jasen Betts wrote:
> On 2012-03-09, Bret Stern <bret_stern@machinemanagement.com> 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.



pgsql-general by date:

Previous
From: leaf_yxj
Date:
Subject: Re: Questions of the privileges to use the pg_cancel_backend and pg_terminate_backend function. Thanks.
Next
From: Lukas Eklund
Date:
Subject: Resize numeric column without changing data?