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 6AEB19FB344 for ; Wed, 16 Aug 2006 14:47:16 -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 66342-06 for ; Wed, 16 Aug 2006 17:46:19 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.170]) by postgresql.org (Postfix) with ESMTP id 301479FB340 for ; Wed, 16 Aug 2006 14:46:18 -0300 (ADT) Received: by ug-out-1314.google.com with SMTP id m3so249238ugc for ; Wed, 16 Aug 2006 10:46:17 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=qnZr/FgcFe0YokBN3HvBxxie8078ACBPaf6Ix/jUGGAjRGzc8ZzIL/0/rqxO3bN5ZuVLARdBwNxaTvpKcskOxF89fSe6xBq4m15EzB+34bi8kca0FdZpeY96qoBJtQddRoXpWa0cnVqphSGQ5pijb8N2TC5bqD7FVBa8+MEmZE4= Received: by 10.67.24.13 with SMTP id b13mr396735ugj; Wed, 16 Aug 2006 08:28:27 -0700 (PDT) Received: by 10.66.234.16 with HTTP; Wed, 16 Aug 2006 08:28:27 -0700 (PDT) Message-ID: Date: Wed, 16 Aug 2006 09:28:27 -0600 From: "=?ISO-8859-1?Q?Rodrigo_De_Le=F3n?=" To: pgsql-sql@postgresql.org Subject: Re: Undo an update In-Reply-To: <44E2DA25.3050104@logix-tt.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <44DCBDD4.20507@correolux.com.mx> <200608151420.07062.kjt@takarnet.hu> <44E2DA25.3050104@logix-tt.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.199 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, SPF_PASS X-Spam-Level: X-Archive-Number: 200608/122 X-Sequence-Number: 26080 On 8/16/06, Markus Schaber wrote: > Hi, Kis, > > Kis J=E1nos Tam=E1s wrote: > > > So, if you send every insert, update, delete command to a > > 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? That's a type of audit trail. It's useful when you what to see what changed, when, and who did it, and let's you revert if necessary, without doing PITR. So, yeah, it's useful. Regards, Rodrigo