Application data refreshing
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????
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:
Show quoted text
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 howto 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????