pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedTime 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