On Thu, Jun 24, 2021 at 6:54 AM Dirk Krautschick
<Dirk.Krautschick@trivadis.com> wrote:
> Is there something planned to get a behaviour like Oracle's flashback query based on the old values
> before deleted by vacuum?
>
> So a feature to recreate old versions of rows if still there?
>
> Or are there any related extensions or tools doing this?
There are some things like pg_dirtyread and probably more. You might
be interested in some of the references in this thread:
https://www.postgresql.org/message-id/flat/CAKLmikOkK%2Bs0V%2B3Pi1vS2GUWQ0FAj8fEkVj9WTGSwZE9nRsCbQ%40mail.gmail.com
As for the SQL standard's approach to this, there are some active
-hackers threads on that with patches in development... look for
"temporal tables" and "system versioned".
