X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id BB0F9D1E138 for ; Fri, 20 Feb 2004 06:05:54 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 55167-03 for ; Fri, 20 Feb 2004 02:05:53 -0400 (AST) Received: from diver.highboard.com (ns5.highboard.com [207.44.244.101]) by svr1.postgresql.org (Postfix) with ESMTP id AB1BFD1E0F1 for ; Fri, 20 Feb 2004 02:05:51 -0400 (AST) Received: from roc-66-67-208-52.rochester.rr.com ([66.67.208.52] helo=swimmer) by diver.highboard.com with asmtp (Exim 4.24) id 1Au3nZ-0002US-Cr for pgsql-admin@postgresql.org; Fri, 20 Feb 2004 01:06:05 -0500 Reply-To: From: "Jeremy Smith" To: Subject: "DELETE FROM" protection Date: Fri, 20 Feb 2004 01:05:33 -0500 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) In-Reply-To: <1832.1077202193@sss.pgh.pa.us> Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - diver.highboard.com X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - highboard.com X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/282 X-Sequence-Number: 12456 This may be an all-time idiotic question, but when I used phpmysql, when I would type in a "DELETE FROM" query in the SQL window, it would make me confirm it before I allowed it to go through. I don't think in all of the presumably thousands of times that I used it that I ever canceled out of the statement, but I always liked that it is there. So now with pgsql, when I am typing "DELETE FROM...." until I get to the "WHERE" part of the statement, I get a little nervous because I know hitting Enter by mistake will wipe out that table. Of course, I have backups, but it is a live site with alot of traffic and I would hate to have to shut things down while I restored the DB. Anyway, this may all seem silly, but is there a setting in pgsql to do this? Thanks, Jeremy