Re: [SQL] Undo A Delete

Поиск
Список
Период
Сортировка
От Brett W. McCoy
Тема Re: [SQL] Undo A Delete
Дата
Msg-id Pine.BSI.3.91.990902162726.8793P-100000@access1.lan2wan.com
обсуждение исходный текст
Ответ на Undo A Delete  (Darren Greer <dgreer@websightsolutions.com>)
Список 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



В списке pgsql-sql по дате отправления:

Предыдущее
От: Darren Greer
Дата:
Сообщение: Undo A Delete
Следующее
От: "pvsree"
Дата:
Сообщение: About table cteation from an sql file