viewing/restoring old rows

Поиск
Список
Период
Сортировка
От David Wright
Тема viewing/restoring old rows
Дата
Msg-id Pine.LNX.4.33.0108151102250.20255-100000@merleau.rprc.washington.edu
обсуждение исходный текст
Ответ на Re: LARGE db dump/restore for upgrade question  (Philip Crotwell <crotwell@seis.sc.edu>)
Список pgsql-general
My understanding of pgSQL is that, when a row is updated or deleted, the
old row is marked as such, but maintained in the DB until I vaccuum.
(This certainly would ease the implementation of transactions.)
Please correct me if I am mistaken. Assuming for now this is true...

Is there  some way to view the old rows or even restore one?

And doesn't this mean a timestamp must be automagically associated with
each row? How do I access these timestamps?


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

Предыдущее
От: "Tamara D. Blum"
Дата:
Сообщение: Error installing postgresql 7.1.2
Следующее
От: wsheldah@lexmark.com
Дата:
Сообщение: Re: LARGE db dump/restore for upgrade question