Обсуждение: Re: Logging the feature of SQL-level read/write commits

Hello,

may be you can find more informations regarding WAL concepts in
Write Ahead Logging — WAL
http://www.interdb.jp/pg/pgsql09.html

It  seems very complicated to change WAL format ...

Maybe there are other solutions to answer your need,
I found many interesting solutions in postgres archives searching
with words "flashback", "timetravel", "tablelog", ...

My prefered is "AS OF queries"
https://www.postgresql.org/message-id/flat/78aadf6b-86d4-21b9-9c2a-51f1efb8a499%40postgrespro.ru

and more specificaly syntax
VERSIONS BETWEEN SYSTEM TIME ... AND ...
that would permit to get history of modifications for some rows
and help fixing current data

Regards
PAscal
Regards
PAscal



--
Sent from: http://www.postgresql-archive.org/PostgreSQL-hackers-f1928748.html