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