Tom Lane wrote:
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > It is hard to understand how a tool would grab the query from the above
> > log except to look for another TAG: entry and stop there.
>
> That was pretty much the centerpiece of my complaint --- up to now it's
> been tremendously difficult to parse the PG logs automatically, and I
> think something along this line would make it much easier.
>
> I am inclined to think though that Bruce has done this in the wrong
> place. If we are going to try to enforce "no real newlines inserted as
> part of logged strings", then it ought to be done at a low level in
> elog.c where it will apply to *everything* that goes into the log, not
> just log_statement/log_duration. For example, we presently allow
> embedded newlines in DETAIL/HINT messages, which is fine for frontend
> messages but helps to render the log unparsable. Those should be
> \n-ified too if we are really interested in making the log easy to
> process.
Agreed. elog is the proper place, because then you guarantee that it is
all on one line. Is that OK? Do we have elogs that we want over
several lines? Is this something we can do at this stage in beta?
Also, my change to pg_stat_activity was wrong, as Rod pointed out --- it
is psql that should handle \n properly, because pgadmin already does.
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
