> 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
> 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.
In response to
pgsql-hackers by date
|Next:||From: Tom Lane||Date: 2000-09-27 14:41:38|
|Subject: Re: Reimplementing permission checks for rules |
|Previous:||From: Philip Warner||Date: 2000-09-27 11:10:12|
|Subject: Change of behaviour of pg_get_userbyid & pg_get_viewdef - do