Re: logging as inserts

Tom,

> That seems a bit bizarre to me.  The facility isn't a new log
> destination; what it is is a different way of formatting what's
> sent to the log.

It's not, but it functions like one.  And ultimately, the destination *is* 
someplace different; likely the DBA will be piping the log output to another 
database somewhere.

> log_message_format = 'INSERT INTO mytab VALUES(%this, %that, ...);'

Yeah, good idea.

> I wonder whether this could be defined in a way that lets it replace
> log_line_prefix ... otherwise we have to think about the interaction of
> the two facilities.

Well, that's why I like the idea of using log_destination.   It makes it clear 
that log_line_prefix doesn't work if log_destination <> 'stderr'.   

-- 
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco