Re: log_destination = csvlog, line breaks interfere in analysis

From: Craig Ringer <ringerc(at)ringerc(dot)id(dot)au>
To: Edson Richter <edsonrichter(at)hotmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: log_destination = csvlog, line breaks interfere in analysis
Date: 2012-09-18 06:35:03
Message-ID: 50581617.3060304@ringerc.id.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Craig Ringer 2012-09-18 06:44:46 Re: RFE: Column aliases in WHERE clauses
Previous Message François Beausoleil 2012-09-18 03:15:05 State of the art for foreign keys to child tables?