Re: Access to old versions of a row

From: Vik Fearing <vik(at)postgresfriends(dot)org>
To: Matthias Apitz <guru(at)unixarea(dot)de>, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: Access to old versions of a row
Date: 2023-10-08 19:35:15
Message-ID: fb4e00e6-6038-4f4c-9296-7cbf803d7501@postgresfriends.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On 10/8/23 16:25, Matthias Apitz wrote:
>
> As long as the vacuum is not run, older versions of a given row should
> be "somewhere". Is there a way to read them?

No.

But there is a pg_dirtyread extension that can do it.
https://github.com/df7cb/pg_dirtyread
--
Vik Fearing

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Andrei Lepikhov 2023-10-09 08:41:09 Re: EXPLAIN Verbose issue - custom_scan_tlist can directly refer CTE and Subquery
Previous Message PG Bug reporting form 2023-10-08 17:41:14 BUG #18151: pg_upgradecluster fails when column default refers to column