Meel Velliste wrote: > 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?
No. Maybe you want a trigger that saves the deleted row somewhere (a separate table perhaps) which you can later inspect and delete again? -- Álvaro Herrera http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
