Received: from access1.lan2wan.com (bmccoy@access1.lan2wan.com [205.177.8.10]) by hub.org (8.9.3/8.9.3) with ESMTP id QAA96951 for ; Thu, 2 Sep 1999 16:19:45 -0400 (EDT) (envelope-from bmccoy@access1.lan2wan.com) Received: (from bmccoy@localhost) by access1.lan2wan.com (8.8.5/) id QAA01284; Thu, 2 Sep 1999 16:29:04 -0400 (EDT) Date: Thu, 2 Sep 1999 16:29:03 -0400 (EDT) From: "Brett W. McCoy" To: Darren Greer cc: "pgsql-sql@postgresql.org" Subject: Re: [SQL] Undo A Delete In-Reply-To: <37CECF68.D8A03598@websightsolutions.com> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII > I dont supose there is a way to undo, or restore, a "delete from table > where...."? Use transactions (BEGIN, COMMIT, ROLLBACK, etc.) If you delete data inside of a transaction and then rollback, your data will be restored. At least I think that's how it's supposed to work! Brett W. McCoy http://www.lan2wan.com/~bmccoy ----------------------------------------------------------------------- The wind doth taste so bitter sweet, Like Jaspar wine and sugar, It must have blown through someone's feet, Like those of Caspar Weinberger. -- P. Opus