| From: | "Brett W(dot) McCoy" <bmccoy(at)lan2wan(dot)com> |
|---|---|
| To: | Darren Greer <dgreer(at)websightsolutions(dot)com> |
| Cc: | "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgreSQL(dot)org> |
| Subject: | Re: [SQL] Undo A Delete |
| Date: | 1999-09-02 20:29:03 |
| Message-ID: | Pine.BSI.3.91.990902162726.8793P-100000@access1.lan2wan.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | pvsree | 1999-09-03 11:49:34 | About table cteation from an sql file |
| Previous Message | Darren Greer | 1999-09-02 19:26:32 | Undo A Delete |