pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Time of table's last changes?
2+ messages / 2 participants
[nested] [flat]

* Time of table's last changes?
@ 1999-10-12 07:25  Pavel Mamin <pm@sky.ru>
  0 siblings, 1 reply; 2+ messages in thread

From: Pavel Mamin @ 1999-10-12 07:25 UTC (permalink / raw)
  To: pgsql-sql

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





^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: [SQL] Time of table's last changes?
@ 1999-10-12 07:40  Mathijs Brands <mathijs@ilse.nl>
  parent: Pavel Mamin <pm@sky.ru>
  0 siblings, 0 replies; 2+ messages in thread

From: Mathijs Brands @ 1999-10-12 07:40 UTC (permalink / raw)
  To: Pavel Mamin <pm@sky.ru>; +Cc: 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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~1999-10-12 07:40 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-10-12 07:25 Time of table's last changes? Pavel Mamin <pm@sky.ru>
1999-10-12 07:40 ` Mathijs Brands <mathijs@ilse.nl>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox