Re: [HACKERS] BUG #3799: csvlog skips some logs

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: depesz <depesz(at)depesz(dot)com>, pgsql-bugs(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org
Subject: Re: [HACKERS] BUG #3799: csvlog skips some logs
Date: 2007-12-09 02:04:04
Message-ID: 475B4D14.9080906@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

Tom Lane wrote:
> Andrew Dunstan <andrew(at)dunslane(dot)net> writes:
>
>> Tom Lane wrote:
>>
>>> One issue here is that CONTEXT is potentially multiple lines. I'm not
>>> sure that there is much we can do about that, especially not at the last
>>> minute. If we had some time to rewrite internal APIs it might be fun to
>>> think about emitting that as array of text not just text, but I fear
>>> it's much too late to consider that now.
>>>
>
>
>> I'm not sure that putting all this into a single extra field would be so
>> wrong. As for an array of text, that doesn't seem very portable. I don't
>> think we should assume that Postgres is the only intended program
>> destination of CSV logs.
>>
>
> Well, I don't see that "{some text,more text,yet more text}" is going
> to be harder to cram into the average CSV-reader than "some text
> more text
> yet more text". However, in most cases split_to_array on newlines
> would be a good enough way of deconstructing the field in Postgres,
> so maybe it's not worth worrying about.
>
> Anyway, I think that we should just make the CSV fields be the same as
> the existing divisions in the textual log format, which seem to have
> stood up well enough in use since 7.4 or whenever we put that scheme in.
>
>
>

OK, works for me. I'll try to look at it after I have attended to the
Windows build issues. My plate is pretty full right now, though.

cheers

andrew

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Adriaan van Os 2007-12-09 09:24:34 BUG #3811: Getting multiple values from a sequence generator
Previous Message Gregory Stark 2007-12-09 00:54:07 Re: BUG #3809: SSL "unsafe" private key permissions bug

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2007-12-09 03:42:01 Bad security practice in oid2name and pgbench
Previous Message Tom Lane 2007-12-08 22:09:49 Re: Possible PostgreSQL 8.3beta4 bug with MD5 authentication in psql?