Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 259219FB602 for ; Sat, 17 Mar 2007 09:00:18 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 95211-06 for ; Sat, 17 Mar 2007 09:00:05 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from localhost.localdomain (unknown [203.199.30.202]) by postgresql.org (Postfix) with ESMTP id 845549FB5E4 for ; Sat, 17 Mar 2007 09:00:05 -0300 (ADT) Received: from localhost.localdomain (ns1 [127.0.0.1]) by localhost.localdomain (8.13.1/8.13.1) with ESMTP id l2HBxhQx017435; Sat, 17 Mar 2007 17:29:43 +0530 Received: (from apache@localhost) by localhost.localdomain (8.13.1/8.13.1/Submit) id l2HBxhe9017434; Sat, 17 Mar 2007 17:29:43 +0530 X-Authentication-Warning: localhost.localdomain: apache set sender to hetal@banasdairy.coop using -f Received: from 10.1.1.52 (SquirrelMail authenticated user hetal) by 10.1.1.31 with HTTP; Sat, 17 Mar 2007 17:29:43 +0530 (IST) Message-ID: <37711.10.1.1.52.1174132783.squirrel@10.1.1.31> In-Reply-To: <1174130632.4925.118.camel@phillip-desktop> References: <41842.10.1.1.52.1174128572.squirrel@10.1.1.31> <1174130632.4925.118.camel@phillip-desktop> Date: Sat, 17 Mar 2007 17:29:43 +0530 (IST) Subject: Re: Rollback From: "Hetal Patel" To: phillip.smith@weatherbeeta.com.au Cc: pgsql-sql@postgresql.org User-Agent: SquirrelMail/1.4.2-1 MIME-Version: 1.0 Content-Type: text/plain;charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Priority: 3 Importance: Normal X-BanasDairy-MailScanner-Information: Please contact the ISP for more information X-BanasDairy-MailScanner: Found to be clean X-BanasDairy-MailScanner-From: hetal@banasdairy.coop X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.186 tagged_above=0 required=5 tests=AWL, BAYES_50, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200703/238 X-Sequence-Number: 27876 Thanks for replyin buddy I had a partial backup and recovered from that will take care next time thanks again > You can not rollback a committed transaction. > > Time to restore some backups - what kind of backup are you using? > > ~p > > On Sat, 2007-03-17 at 16:19 +0530, Hetal Patel wrote: > >> Hello Friends >> New to postgresql >> I m in trouble >> I fired a query a "DELETE" query from a PGADMIN III postgresql tool >> Which have deleted some rows which shud ve not been deleted >> How do i get it rollback >> I mean i want all the rows back >> Please help me >> Its urgent >> Thanks in advance for Help >> >> >> Hetal Patel >> System Dept. >> Banasdairy >> > > > *******************Confidentiality and Privilege Notice******************* > > The material contained in this message is privileged and confidential to > the addressee. If you are not the addressee indicated in this message or > responsible for delivery of the message to such person, you may not copy > or deliver this message to anyone, and you should destroy it and kindly > notify the sender by reply email. > > Information in this message that does not relate to the official business > of Weatherbeeta must be treated as neither given nor endorsed by > Weatherbeeta. > Weatherbeeta, its employees, contractors or associates shall not be liable > for direct, indirect or consequential loss arising from transmission of > this > message or any attachments > > -- > This message has been scanned for viruses and > dangerous content by MailScanner, and is > believed to be clean. > > Hetal Patel System Dept. Banasdairy -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.