Re: Finding time in WAL logs

[Pascal Robert <probert(at)os(dot)ca>]

> > 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 ?