Hi,
not experienced on all that, but I'd suggest...
>PostgreSQL 7.1 Developer's Guide
>Ch. 4.2.4 Notification Responses, pg. 27
>
>>If a frontend issues a listen(1) command, the backend will send a
>>
>NotificationResponse message whenever a notify(1) command is executed for
>the same notification name.
>
>a notify(1) command executed by another client?
>
YES. (from other posts on this group)
>PostgreSQL 7.1 Programmer's Guide
>Ch. 1.5 Asynchronous Notification, pg 14
>
>>A backend registers its interest in a particular notification with the
>>
>LISTEN command...
>
>A backend? But you just said frontend!
>
Well, maybe...
>How do I make the PostgreSQL server notify me when my view (of the model)
>has changed?
>
I'd bet you can use TRIGGERs to NOTIFY a client that has previously
issued a LISTEN command.
>I'm reading the documentation with great anticipation; but anybody with
>personal experience may be able to direct me to the appropriate
>literature.
>
I can't tell you much more, as most I learnt was from this list. (Thank
you all!!!)
Antonio Fiol
>
>
>Thanks,
>
>Patrick Henry, MCDL
>Brunswick Ohio, 44212 USA
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
>.
>