Received: from hotmail.com (oe42.law8.hotmail.com [216.33.240.100]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f722ENf75611 for ; Wed, 1 Aug 2001 22:14:23 -0400 (EDT) (envelope-from yasuo_ohgaki@hotmail.com) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Wed, 1 Aug 2001 19:14:12 -0700 X-Originating-IP: [210.154.73.126] From: "Yasuo Ohgaki" To: "Sunit Bhatia" Cc: References: Subject: Re: Data Versioning Date: Thu, 2 Aug 2001 11:13:01 +0900 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-2022-jp" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 Message-ID: X-OriginalArrivalTime: 02 Aug 2001 02:14:12.0592 (UTC) FILETIME=[D2528700:01C11AF8] X-Archive-Number: 200108/31 X-Sequence-Number: 13251 > Does any body know if pgsql supports any kind of versioning of binary > objects or data. e.g. If I'm storing a binary file in a row of a table, I > would want to see different versions of the same biary file. Everytime I do > a write, the version number should be bumped up !! With PostgreSQL, you can create RULE to keep old values. (Much easier than other DB, thanks to RULE) Refer to PostgreSQL manual for details. Yasuo Ohgaki