Re: back-end triggers front-end to update

From: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>
To: Adam O'Toole <adamnb1(at)hotmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: back-end triggers front-end to update
Date: 2005-07-26 21:44:02
Message-ID: 1122414242.15145.94.camel@state.g2switchworks.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, 2005-07-26 at 16:25, Adam O'Toole wrote:
> Hello everyone,
> I am searching for a way to have my postgresql 7.4.7 backend be
> triggered to let the front end know there has been a change to the
> database. If more then one person is connected to the database and
> person (x) makes a change, I want other clients to then be aware of
> that, and refresh there screen so they are not then looking at out of
> date data.
> Any insight? Thank you so much, have a great day.

I believe the tools you are looking for are triggers and notify /
listen...

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Warren White 2005-07-26 21:48:16 postgres 7.2.4 - errors after vacuuming/reindexing in single user mode
Previous Message Merlin Moncure 2005-07-26 21:30:49 Re: ENUM type