Re: Is there something similar like flashback query from Oracle planned for PostgreSQL

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".