On Apr 25, 2007, at 7:01 PM, Simon Riggs wrote:
(this is for a DELETE FROM table without any WHERE clause). I see the XID, but can you also display date and time in the ouput ?Original date/time is available only on COMMIT/ABORT records, so you'llneed to search ahead/behind.
Additionally, you can specify an XID when doing a point-in-time restore; you don't need to find an exact time to restore to.
-- Jim Nasby jim@xxxxxxxxx EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)