I think you can do this with the listen/notify commands. I've never done
it myself, but take a look at
http://www.postgresql.org/users-lounge/docs/7.0/programmer/pgtcl-pglisten.htm
and some of the other Postgres docs and you should be able to figure it
out. From what I read, you have your programs send a notify after doing an
update, then the other's are all listening for that notify, and then can be
instructed to reload the data.
At 02:23 AM 9/21/00, Jesus Sandoval wrote:
>I tried to find information in the lists but got no luck.
>
>I want to make a client application that performs a query to show the
>results, but the client application stays open and the database gets
>updated.
>
>I want that the updates of the database reflects on the open client
>application, I think this can be done with triggers but I'm not sure how
>
>to do this if there are 3 (or more) client applications open at the same
>
>time, how the trigger can send a refresh to the 3 (or more) of them.
>
>Can anybody help me????