>> 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
> need to search ahead/behind.
Ok, so I guess that auto commited statements will never have date/time ?
In response to
pgsql-admin by date
|Next:||From: Pascal Robert||Date: 2007-04-25 19:20:28|
|Subject: Re: Finding time in WAL logs|
|Previous:||From: Karthikeyan Sundaram||Date: 2007-04-25 18:27:44|
|Subject: question about installing perl module|