Re: [SQL] Time of table's last changes?

From: Mathijs Brands <mathijs(at)ilse(dot)nl>
To: Pavel Mamin <pm(at)sky(dot)ru>
Cc: pgsql-sql(at)postgreSQL(dot)org
Subject: Re: [SQL] Time of table's last changes?
Date: 1999-10-12 07:40:41
Message-ID: 19991012094041.A3691@ilse.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Tue, Oct 12, 1999 at 01:25:56PM +0600, Pavel Mamin allegedly wrote:
> Please, help me:
>
> Is there any way to know at what time the data in some table were
> changed last time? - to check this time and if it is changed, re-download data from
> that table - in cases when the table is too big.
>
> Now I use for such thing the rules on insert, update and delete. But
> if the changes are too intensive it's not an escape.
>
> Pavel Mamin,
> Network Programmer,
> SkyNet Co. ISP, Yekaterinburg, Russia

Couldn't you do this with a trigger?

Mathijs

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Herouth Maoz 1999-10-12 09:53:44 Re: [SQL] security: escaping user-supplied data
Previous Message Pavel Mamin 1999-10-12 07:25:56 Time of table's last changes?