Re: log_destination = csvlog, line breaks interfere in analysis - Mailing list pgsql-general

From Craig Ringer
Subject Re: log_destination = csvlog, line breaks interfere in analysis
Date
Msg-id 50581617.3060304@ringerc.id.au
Whole thread Raw
In response to log_destination = csvlog, line breaks interfere in analysis  (Edson Richter <edsonrichter@hotmail.com>)
Responses Re: log_destination = csvlog, line breaks interfere in analysis  ("Albe Laurenz" <laurenz.albe@wien.gv.at>)
List pgsql-general
On 09/18/2012 03:21 AM, Edson Richter wrote:

> 2012-09-17 14:25:33.150
> BRT,"thedb","thedb",15660,"10.10.20.1:33485",5054d3ab.3d2c,1,"SELECT",2012-09-15
> 16:14:51 BRT,10/204822,0,LOG,00000,"duração: 505.494 ms  executar
> <unnamed>: select A, B
>      from C join D
>           on C.id = D.c_id
>
> And so on.

Yick. That doesn't seem very CSV-like. I'm very surprised Pg isn't
stripping newlines.

> It's not possible to change the application (hours of testing after
> changes will not be feasible for 2 million LOC).

No automated testing is in place?

It's not perfect, but it goes a long way toward improving confidence in
changes to big (or small) codebases.

--
Craig Ringer


pgsql-general by date:

Previous
From: François Beausoleil
Date:
Subject: State of the art for foreign keys to child tables?
Next
From: Craig Ringer
Date:
Subject: Re: RFE: Column aliases in WHERE clauses