On Thu, Jun 24, 2021 at 6:54 AM Dirk Krautschick <dirk.krautsch...@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".
