From: | Charles Tassell <ctassell(at)isn(dot)net> |
---|---|
To: | Jesus Sandoval <meli(at)mzt(dot)megared(dot)net(dot)mx>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Application data refreshing |
Date: | 2000-09-21 21:35:11 |
Message-ID: | 4.3.2.7.2.20000921183322.04bc93d0@mailer.isn.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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????
From | Date | Subject | |
---|---|---|---|
Next Message | Charles Tassell | 2000-09-21 21:45:00 | Re: Re: sequences |
Previous Message | Richard Harvey Chapman | 2000-09-21 21:17:34 | Re: problem with CREATE FUNCTION |