Re: log_destination = csvlog, line breaks interfere in analysis

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