pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Undo A Delete
2+ messages / 2 participants
[nested] [flat]

* Undo A Delete
@ 1999-09-02 19:26 Darren Greer <dgreer@websightsolutions.com>
  1999-09-02 20:29 ` Re: [SQL] Undo A Delete Brett W. McCoy <bmccoy@lan2wan.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Darren Greer @ 1999-09-02 19:26 UTC (permalink / raw)
  To: pgsql-sql

I dont supose there is a way to undo, or restore, a "delete from table
where...."?

Any thoughts appreciated.

Darren


--
Darren Greer
System Administrator -
Applications Development Manager
Websight Solutions Inc.
Phone: (414) 790-9327 | Fax: (414) 790-5952





^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: [SQL] Undo A Delete
  1999-09-02 19:26 Undo A Delete Darren Greer <dgreer@websightsolutions.com>
@ 1999-09-02 20:29 ` Brett W. McCoy <bmccoy@lan2wan.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Brett W. McCoy @ 1999-09-02 20:29 UTC (permalink / raw)
  To: Darren Greer <dgreer@websightsolutions.com>; +Cc: 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




^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~1999-09-02 20:29 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-09-02 19:26 Undo A Delete Darren Greer <dgreer@websightsolutions.com>
1999-09-02 20:29 ` Brett W. McCoy <bmccoy@lan2wan.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox