Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 2F2519FBDC9 for ; Wed, 25 Apr 2007 15:49:43 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 73412-03 for ; Wed, 25 Apr 2007 15:49:39 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from osci.qc.ca (cgp.osci.qc.ca [216.113.25.150]) by postgresql.org (Postfix) with ESMTP id 4EA099FBE5B for ; Wed, 25 Apr 2007 15:49:39 -0300 (ADT) Received: from [192.168.3.143] (account probert [192.168.3.143] verified) by osci.qc.ca (CommuniGate Pro SMTP 5.0.13) with ESMTPA id 9053514; Wed, 25 Apr 2007 14:49:38 -0400 In-Reply-To: <1177524100.20637.167.camel@silverbirch.site> References: <5B0132B1-646A-432C-8261-973E4BB42999@os.ca> <1177515789.20637.160.camel@silverbirch.site> <7697F772-07E3-469C-8E51-1450AEBC5F39@os.ca> <1177524100.20637.167.camel@silverbirch.site> Mime-Version: 1.0 (Apple Message framework v752.3) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: Cc: Content-Transfer-Encoding: 7bit From: Pascal Robert Subject: Re: Finding time in WAL logs Date: Wed, 25 Apr 2007 14:49:14 -0400 To: Simon Riggs X-Mailer: Apple Mail (2.752.3) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/237 X-Sequence-Number: 25301 >> 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 ?