Received: from serv0.ilse.net (serv0.ilse.nl [194.158.182.236]) by hub.org (8.9.3/8.9.3) with ESMTP id DAA95115 for ; Tue, 12 Oct 1999 03:41:01 -0400 (EDT) (envelope-from mathijs@ilse.nl) Received: (from mathijs@localhost) by serv0.ilse.net (8.8.8/8.6.12) id JAA03715; Tue, 12 Oct 1999 09:40:41 +0200 (MET DST) Date: Tue, 12 Oct 1999 09:40:41 +0200 From: Mathijs Brands To: Pavel Mamin Cc: pgsql-sql@postgreSQL.org Subject: Re: [SQL] Time of table's last changes? Message-ID: <19991012094041.A3691@ilse.nl> References: <4559.991012@sky.ru> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 1.0pre3i In-Reply-To: <4559.991012@sky.ru> X-Unexpected-Header: The Spanish Inquisition 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