Re: last update time of a table

Thanks for your suggestion. I think this is exactly Karsten and Mike said :

create triggers to notify the client for any kind of updates.

I'm not sure whether VB can handle such events, so I have to further study
on this.

-Jason

----- Original Message -----
From: "Claudio Lapidus" <clapidus(at)hotmail(dot)com>
To: "pg" <pg(at)newhonest(dot)com>; <pgsql-general(at)postgresql(dot)org>
Sent: Sunday, December 07, 2003 11:09 PM
Subject: Re: [GENERAL] last update time of a table

> pg wrote:
> > I have some pulldown menus in a VB app which extract data
> > from a remote site with slow connection. And the data in those tables
for
> > pulldowns changes rarely. So if the pulldown has to extract the data and
> > transmit it thru slow connection, the pulldown will take a few seconds
to
> be
> > in action, which is a little bit annoying, especially if the data is the
> > same as in the array of client.
>
> Probably you'll do it better storing a local cached copy of the pulldown
> data (in the VB side) and having a background process to refresh it only
> when the server notifies that it has changed.
>
> hth
> cl.
>