Re: [SQL] Undo A Delete

Brett W. McCoy <bmccoy@lan2wan.com>

From: "Brett W. McCoy" <bmccoy@lan2wan.com>
To: Darren Greer <dgreer@websightsolutions.com>
Cc: "pgsql-sql@postgresql.org" <pgsql-sql@postgreSQL.org>
Date: 1999-09-02T20:29:03Z
Lists: pgsql-sql
> 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