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 jim@nasby.net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)