Using xmax to detect deleted rows

From: Meel Velliste <meel(dot)velliste(at)gmail(dot)com>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Using xmax to detect deleted rows
Date: 2016-01-08 07:37:45
Message-ID: CAKDa2+ngAO2tBNaPbO_bejuHLXfNcoV2KAQFpYG_tF+ibpHhuA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I would like to use the "xmax" column to detect rows that have been
recently deleted. Is it possible to get the deleted row versions with
non-zero xmax to remain visible long enough that I could periodically
check, say once an hour, and still be able to see rows that were deleted
since I last checked?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Charles Clavadetscher 2016-01-08 07:42:46 Re: Function error
Previous Message Pavel Stehule 2016-01-08 07:35:33 Re: Function error