On Wed, 2007-04-25 at 14:49 -0400, Pascal Robert wrote: > >> BTW, the statements look like this : > >> > >> 0/15FFE470: prv 0/15FFE440; xid 2332; HEAP info 10 len 18 > >> tot_len 46 > >> DELETE FROM 16612 WHERE ...delete: ts 1663 db 16384 rel 16612 block > >> 1413 off 5 > >> > >> (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. > > Ok, so I guess that auto commited statements will never have date/time ?
There'll be a COMMIT record for every transaction, however it was initiated, unless the server crashed/shutdown before it could be issued. -- Simon Riggs EnterpriseDB http://www.enterprisedb.com ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
