Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group