historical log of data records

Поиск
Список
Период
Сортировка
От Sanjay Minni
Тема historical log of data records
Дата
Msg-id CAMpxBo=xMvQOk--tSp7mkChUwfJfbbtSfQE=S6O2pELGSvQvjQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: historical log of data records
Re: historical log of data records
Список pgsql-general
I need to keep a copy of old data as the rows are changed. 

For a general RDBMS I could think of keeping all the data in the same table with a flag to indicate older copies of updated /  deleted rows or keep a parallel table and copy these rows into the parallel data under program / trigger control. Each has its pros and cons. 

In Postgres would i have to follow the same methods or are there any features / packages available ?

regards
Sanjay Minni

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

Предыдущее
От: "Chen, Yan-Jack (NSB - CN/Hangzhou)"
Дата:
Сообщение: RE: PostgreSQL debug log doesn't record whole procedure(from receiving request to sending response)
Следующее
От: Sanjay Minni
Дата:
Сообщение: reading this group other than thru mails