Postgres Pro
Downloads
Home   >   mailing lists

Re: Access to old versions of a row - Mailing list pgsql-bugs

From Vik Fearing
Subject Re: Access to old versions of a row
Date
Msg-id fb4e00e6-6038-4f4c-9296-7cbf803d7501@postgresfriends.org
Whole thread Raw
In response to Access to old versions of a row  (Matthias Apitz <guru@unixarea.de>)
Responses Re: Access to old versions of a row  (Andres Freund <andres@anarazel.de>)
List pgsql-bugs
Tree view 
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

pgsql-bugs by date:

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