Re: Dynamic application data refreshing - Mailing list pgsql-hackers

From Papp Gyozo
Subject Re: Dynamic application data refreshing
Date
Msg-id Pine.GSO.4.21.0009261206250.21443-100000@ural2
Whole thread Raw
In response to Dynamic application data refreshing  (Jesus Sandoval <meli@mzt.megared.net.mx>)
List 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@hszk.bme.hu, gerzson17@freemail.hu






pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: use of / in ~ vs. ~*
Next
From: Tom Lane
Date:
Subject: Re: Reimplementing permission checks for rules