Re: View deleted records in a table - Mailing list pgsql-general

From Adrian Klaver
Subject Re: View deleted records in a table
Date
Msg-id 56F9355F.2010305@aklaver.com
Whole thread Raw
In response to Re: View deleted records in a table  (Boyan Botev <bbotev@gmail.com>)
List pgsql-general
On 03/26/2016 12:47 PM, Boyan Botev wrote:
> Thanks, Adrian! That worked great for what I needed. I greatly
> appreciate your help. Do you know if there is a way to also display
> system columns like xmin, xmax with this extension. I can see the need
> for that in some future investigation.

You are not the only one:

http://www.depesz.com/2012/04/04/lets-talk-dirty/

"I would definitely add information about xmin/xmax to outputted columns
– this is required to be able to tell which row is latest, and which was
previous"


I would suggest filing an issue here:

https://github.com/omniti-labs/pgtreats/tree/master/contrib/pg_dirtyread

> Thanks,
> Boyan
>

--
Adrian Klaver
adrian.klaver@aklaver.com


pgsql-general by date:

Previous
From: Jehan-Guillaume de Rorthais
Date:
Subject: Re: Unique values on multiple tables
Next
From: Geoff Winkless
Date:
Subject: More correlated (?) index woes