Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id C33AA9FB558 for ; Sat, 17 Mar 2007 07:56:48 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 09853-03 for ; Sat, 17 Mar 2007 07:56:45 -0300 (ADT) X-Greylist: delayed 00:06:46.15321 by SQLgrey-1.7.4 Received: from localhost.localdomain (unknown [203.199.30.202]) by postgresql.org (Postfix) with ESMTP id 725D09FB4D4 for ; Sat, 17 Mar 2007 07:56:42 -0300 (ADT) Received: from localhost.localdomain (ns1 [127.0.0.1]) by localhost.localdomain (8.13.1/8.13.1) with ESMTP id l2HAnXfh015191 for ; Sat, 17 Mar 2007 16:19:33 +0530 Received: (from apache@localhost) by localhost.localdomain (8.13.1/8.13.1/Submit) id l2HAnW2A015190; Sat, 17 Mar 2007 16:19:32 +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 16:19:32 +0530 (IST) Message-ID: <41842.10.1.1.52.1174128572.squirrel@10.1.1.31> Date: Sat, 17 Mar 2007 16:19:32 +0530 (IST) Subject: Rollback From: "Hetal Patel" To: 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.136 tagged_above=0 required=5 tests=BAYES_50, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200703/236 X-Sequence-Number: 27874 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 -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.