Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 92A9E64FCE0 for ; Fri, 25 Jul 2008 08:47:33 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 20428-05 for ; Fri, 25 Jul 2008 08:47:26 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from easy2.in-chemnitz.de (easy2.in-chemnitz.de [88.198.17.232]) by postgresql.org (Postfix) with ESMTP id B2E4564FCD7 for ; Fri, 25 Jul 2008 08:47:30 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by easy2.in-chemnitz.de (Postfix) with ESMTP id 5E47E47001D for ; Fri, 25 Jul 2008 13:47:28 +0200 (CEST) Received: from easy2.in-chemnitz.de ([127.0.0.1]) by localhost (easy.in-chemnitz.de [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id n+s-T1BJlQkQ for ; Fri, 25 Jul 2008 13:47:28 +0200 (CEST) Received: by easy2.in-chemnitz.de (Postfix, from userid 1013) id 4D1C6470002; Fri, 25 Jul 2008 13:47:28 +0200 (CEST) Date: Fri, 25 Jul 2008 13:47:28 +0200 From: Tino Schwarze To: pgsql-admin@postgresql.org Subject: Re: How to recover deleted data........ Message-ID: <20080725114728.GC6464@easy2.in-chemnitz.de> References: <4b393c0d0807250419j6e337e8dk9c420003be63d03@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <4b393c0d0807250419j6e337e8dk9c420003be63d03@mail.gmail.com> User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200807/215 X-Sequence-Number: 29825 On Fri, Jul 25, 2008 at 04:49:48PM +0530, neo3 matrix wrote: > I have a table property_details having columns (mid,pid,pv,vt) > Accidentally , i fired a query > delete from property_details where mid=27617 and pid=20 or pid=21 or pid=22 > , which resulted in deletion of 418 rows which had pids 21 and 22 , which i > don't want....... > So , plz can anyone help me out to recover all those rows having pid=21 and > pid=22 ............... If you did that without a transaction, things might become very complicated to restore and might require lots of fiddling. The easiest way is to restore from backup. Tino. -- "What we nourish flourishes." - "Was wir nähren erblüht." www.craniosacralzentrum.de www.forteego.de