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 BF9459FB285 for ; Fri, 11 Aug 2006 14:42:00 -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 69263-01 for ; Fri, 11 Aug 2006 17:41:53 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.174]) by postgresql.org (Postfix) with ESMTP id C15C59FB1E7 for ; Fri, 11 Aug 2006 14:41:52 -0300 (ADT) Received: by ug-out-1314.google.com with SMTP id m3so924626ugc for ; Fri, 11 Aug 2006 10:41:51 -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=QQfHSowlN8JYHZT00ei3Ox82eqoYXqcm47/1juysv82POyrj44aFOd3a4vN/Vdu1u2iRsUP5kYb9riorOaM8oIi1Ida0D9egq5DgmmBSKlbr3YvrX+2TAtWcaR5M732Y+SzKl/DsSESJVvGkOGpbyHeQ47j3d0CVPV7BADauHbk= Received: by 10.67.93.7 with SMTP id v7mr4380496ugl; Fri, 11 Aug 2006 10:41:51 -0700 (PDT) Received: by 10.66.234.16 with HTTP; Fri, 11 Aug 2006 10:41:51 -0700 (PDT) Message-ID: Date: Fri, 11 Aug 2006 11:41:51 -0600 From: "=?ISO-8859-1?Q?Rodrigo_De_Le=F3n?=" To: pgsql-sql@postgresql.org Subject: Re: Undo an update In-Reply-To: <44DCBDD4.20507@correolux.com.mx> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <44DCBDD4.20507@correolux.com.mx> 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/87 X-Sequence-Number: 26045 If it was inside a transaction, and the transaction is still open, then just rollback. Otherwise, no. I'm not sure if there's any way of doing some kind of PITR, no familiar with it. If not, best bet is to recover from the newest backup set you have. Regards, Rodrigo