X-Original-To: pgsql-sql-postgresql.org@postgresql.org
Received: from localhost (wm.hub.org [200.46.204.128])
	by postgresql.org (Postfix) with ESMTP id 53DBD9FB2B5
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Wed, 16 Aug 2006 05:41:01 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024)
	with ESMTP id 90848-10 for <pgsql-sql-postgresql.org@postgresql.org>;
	Wed, 16 Aug 2006 08:40:52 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from mail.logix-tt.com (mail.logix-tt.com [212.211.145.186])
	by postgresql.org (Postfix) with ESMTP id 90F6F9FAE4E
	for <pgsql-sql@postgresql.org>; Wed, 16 Aug 2006 05:40:52 -0300 (ADT)
Received: from kingfisher.intern.logix-tt.com (p549D2216.dip0.t-ipconnect.de
	[84.157.34.22])
	(using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits))
	(No client certificate requested)
	by mail.logix-tt.com (Postfix) with ESMTP id D496565942;
	Wed, 16 Aug 2006 10:42:53 +0200 (CEST)
Received: from [127.0.0.1] (localhost [127.0.0.1])
	by kingfisher.intern.logix-tt.com (Postfix) with ESMTP id 6ED011853ECD0;
	Wed, 16 Aug 2006 10:41:09 +0200 (CEST)
Message-ID: <44E2DA25.3050104@logix-tt.com>
Date: Wed, 16 Aug 2006 10:41:09 +0200
From: Markus Schaber <schabi@logix-tt.com>
Organization: Logical Tracking and Tracing International AG, Switzerland
User-Agent: Thunderbird 1.5.0.4 (X11/20060713)
MIME-Version: 1.0
To: =?ISO-8859-15?Q?Kis_J=E1nos_Tam=E1s?= <kjt@takarnet.hu>
Cc: pgsql-sql@postgresql.org
Subject: Re: Undo an update
References: <44DCBDD4.20507@correolux.com.mx>
	<200608151420.07062.kjt@takarnet.hu>
In-Reply-To: <200608151420.07062.kjt@takarnet.hu>
X-Enigmail-Version: 0.94.0.0
Content-Type: text/plain; charset=ISO-8859-15
Content-Transfer-Encoding: quoted-printable
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.135 tagged_above=0 required=5 tests=FORGED_RCVD_HELO
X-Spam-Level: 
X-Archive-Number: 200608/118
X-Sequence-Number: 26076

Hi, Kis,

Kis J=E1nos Tam=E1s wrote:

> So, if you send every insert, update, delete command to a=20
> logger-table, then you can to undo anything.

But this is just re-inventing the wheel, we already have Point-in-Time
recovery.

Or do I miss something?


Markus


--=20
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.=
org