Re: Access to old versions of a row

Поиск
Список
Период
Сортировка
От Vik Fearing
Тема Re: Access to old versions of a row
Дата
Msg-id fb4e00e6-6038-4f4c-9296-7cbf803d7501@postgresfriends.org
обсуждение исходный текст
Ответ на Access to old versions of a row  (Matthias Apitz <guru@unixarea.de>)
Ответы Re: Access to old versions of a row  (Andres Freund <andres@anarazel.de>)
Список 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




В списке pgsql-bugs по дате отправления:

Предыдущее
От: PG Bug reporting form
Дата:
Сообщение: BUG #18151: pg_upgradecluster fails when column default refers to column
Следующее
От: Andrei Lepikhov
Дата:
Сообщение: Re: EXPLAIN Verbose issue - custom_scan_tlist can directly refer CTE and Subquery