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'll
need 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 [EMAIL PROTECTED]
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
