Re: DELETE and efficiency

Поиск
Список
Период
Сортировка
От Dan Lyke
Тема Re: DELETE and efficiency
Дата
Msg-id 15015.60884.719975.768541@wynand.flutterby.com
обсуждение исходный текст
Ответ на Re: DELETE and efficiency  (Michelle Murrain <mpm@norwottuck.com>)
Список pgsql-general
Michelle Murrain writes:
> Is that so? If so, that means there might be a way to do an
> undelete? What is it?

As I understand it there's no way to do an undelete because of the way
that transactions get handled, but it does suggest that there are
places where a "deleted char(1)" (or however you want to implement it)
field can be quite handy, especially given the ridiculously cheap
price of disk space (modulo backup...) nowadays.

In applications, confirmation is a cop-out for those too lazy to
implement undo (okay, that's overstating the case a bit), but
structuring your data to acknowledge this at the beginning can be a
worthwhile exercise.

Dan

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: inheritance and primary/foreign keys
Следующее
От: Gilles DAROLD
Дата:
Сообщение: Shell env and PL/SQL