Re: [BUGS] BUG #3799: csvlog skips some logs - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: [BUGS] BUG #3799: csvlog skips some logs
Date
Msg-id 20071211152850.GF10710@alvh.no-ip.org
Whole thread Raw
In response to Re: [BUGS] BUG #3799: csvlog skips some logs  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [BUGS] BUG #3799: csvlog skips some logs
List pgsql-hackers
Tom Lane wrote:
> Alvaro Herrera <alvherre@alvh.no-ip.org> writes:
> > Another change I did was to change a "%.*s" to "%*s".  The "precision"
> > marker seems useless AFAICT.
> 
> This is wrong, broken, will cause crashes on platforms where the PS
> string is not null-terminated.  (Hint: .* is a maximum width, * is a
> minimum width.)

Oh, OK.

> Another thing I thought strange was the order of the added columns;
> why isn't it more like the order in which they appear in the text
> version?  In particular hint should probably come just after detail
> and before context, and internal-query should also come before context
> because when relevant it's usually more closely nested than the context
> stack.

Ok, I changed it like you suggest.  I didn't do any other order changes.
I still propose that the log line number should be moved w.r.t. session
identifier.

I changed two more things: the VXID is not reported if not in a backend
(because AuxiliaryProcesses are said to never have one), and added
quotes surrounding the hostname, because in a test here it seems
supported to create an alias for my loopback interface with a name like
"a,b".

-- 
Alvaro Herrera                 http://www.amazon.com/gp/registry/DXLWNGRJD34J
"All rings of power are equal,
But some rings of power are more equal than others."                                (George Orwell's The Lord of the
Rings)


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: WORM and Read Only Tables (v0.1)
Next
From: Andrew Chernow
Date:
Subject: Re: PGparam proposal