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 1E842D1E14C for ; Fri, 20 Feb 2004 10:56:41 +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 29210-06 for ; Fri, 20 Feb 2004 06:56:39 -0400 (AST) Received: from magic.lif.icnet.uk (unknown [143.65.100.6]) by svr1.postgresql.org (Postfix) with ESMTP id C5BC7D1E14A for ; Fri, 20 Feb 2004 06:56:35 -0400 (AST) Received: from atlantis.ox.icnet.uk (atlantis.ox.icnet.uk [143.65.27.60]) by magic.lif.icnet.uk (8.9.3p2/8.9.3) with ESMTP id KAA22086 for ; Fri, 20 Feb 2004 10:56:12 GMT Received: from nemesis.ox.icnet.uk (mail@nemesis.ox.icnet.uk [143.65.27.59]) by atlantis.ox.icnet.uk (8.12.6/8.12.6) with ESMTP id i1KAu6iT001086 for ; Fri, 20 Feb 2004 10:56:06 GMT Received: from davee by nemesis.ox.icnet.uk with local (Exim 3.36 #1 (Debian)) id 1Au8KF-0006Xj-00 for ; Fri, 20 Feb 2004 10:56:07 +0000 Date: Fri, 20 Feb 2004 10:56:07 +0000 From: Dave Ewart To: pgsql-admin@postgresql.org Subject: Re: "DELETE FROM" protection Message-ID: <20040220105607.GM3555@nemesis.ox.icnet.uk> Mail-Followup-To: pgsql-admin@postgresql.org References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.4i X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/284 X-Sequence-Number: 12458 On Friday, 20.02.2004 at 10:12 +0000, Matt Clark wrote: > > 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. [...] How about typing the "WHERE" part of the statement first, then 'left-arrowing' back to the start of the statement and do "DELETE FROM ..." *last*? Dave. -- Dave Ewart Dave.Ewart@cancer.org.uk Computing Manager, Epidemiology Unit, Oxford Cancer Research UK PGP: CC70 1883 BD92 E665 B840 118B 6E94 2CFD 694D E370