Re: Dynamic application data refreshing

From: Papp Gyozo <s7461pap(at)hszk(dot)bme(dot)hu>
To: Jesus Sandoval <meli(at)mzt(dot)megared(dot)net(dot)mx>
Cc: pgsql-hackers(at)hub(dot)org
Subject: Re: Dynamic application data refreshing
Date: 2000-09-27 11:20:05
Message-ID: Pine.GSO.4.21.0009261206250.21443-100000@ural2
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> 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.

I'm not familiar with the following SQL statements, but I think these
could be useful:

LISTEN and NOTIFY.

Papp Gyozo

s7461pap(at)hszk(dot)bme(dot)hu, gerzson17(at)freemail(dot)hu

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2000-09-27 14:41:38 Re: Reimplementing permission checks for rules
Previous Message Philip Warner 2000-09-27 11:10:12 Change of behaviour of pg_get_userbyid & pg_get_viewdef - do it?