Received: from cray.sky.ru (sky-rtk2.sky.ru [195.161.194.226]) by hub.org (8.9.3/8.9.3) with ESMTP id DAA93270 for ; Tue, 12 Oct 1999 03:26:28 -0400 (EDT) (envelope-from pm@sky.ru) Received: from pm.sky.ru (pm.sky.ru [195.161.194.26]) by cray.sky.ru (8.9.3/8.9.3) with SMTP id NAA14611 for ; Tue, 12 Oct 1999 13:28:22 +0600 Date: Tue, 12 Oct 1999 13:25:56 +0600 From: Pavel Mamin X-Mailer: The Bat! (v1.33) UNREG / CD5BF9353B3B7091 Reply-To: Pavel Mamin X-Priority: 3 (Normal) Message-ID: <4559.991012@sky.ru> To: pgsql-sql@postgreSQL.org Subject: Time of table's last changes? Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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