Tom Lane wrote:
> Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)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.)
> 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
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
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
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)
In response to
pgsql-hackers by date
|Next:||From: Simon Riggs||Date: 2007-12-11 15:31:36|
|Subject: Re: WORM and Read Only Tables (v0.1)|
|Previous:||From: Tom Lane||Date: 2007-12-11 15:19:27|
|Subject: Re: WORM and Read Only Tables (v0.1) |
pgsql-bugs by date
|Next:||From: Tom Lane||Date: 2007-12-11 15:45:22|
|Subject: Re: [HACKERS] BUG #3799: csvlog skips some logs |
|Previous:||From: Alvaro Herrera||Date: 2007-12-11 15:03:22|
|Subject: Re: [HACKERS] BUG #3799: csvlog skips some logs|