Received: from hotmail.com (oe7.pav1.hotmail.com [64.4.30.111]) by hub.org (8.10.1/8.10.1) with ESMTP id e7TAljC43036 for ; Tue, 29 Aug 2000 06:47:45 -0400 (EDT) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Tue, 29 Aug 2000 03:47:39 -0700 X-Originating-IP: [195.64.69.13] From: "Craig Manley" To: Subject: How do you detect row version changes in PostgreSQL? Date: Tue, 29 Aug 2000 12:46:40 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2615.200 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200 Message-ID: X-OriginalArrivalTime: 29 Aug 2000 10:47:39.0773 (UTC) FILETIME=[8D35CAD0:01C011A6] X-Archive-Number: 200008/318 Hi all, Some databases have a hidden field that contains a row version key. Everytime an update is performed on a row the value of the version field changes. Does PostgreSQL have a similar hidden field? If not then I guess using a before update trigger that modifies a user defined field will provide an alternative solution. Greetings, Craig Manley.