Guillaume Smet escribió:
> On 2/19/07, Greg Smith <[EMAIL PROTECTED]> wrote:
> >log_destination = 'stderr,sql'     # Valid values are combinations of
> >                     # stderr, syslog, sql, and eventlog,
> >                     # depending on platform.
> +1

Please don't do that.  We already have a "combined GUC option" that is
used to change two different things (DateStyle) and I regularly see
people confused about how to use it.

Also, "sql" is not really a destination -- it is a format.  Maybe have a
"format=plain,sql" GUC var is best: plain format is logged as currently,
and SQL format is logged somewhere else (maybe use the same name, and
stash a .sql suffix to the filename, or use .sql.log).  That way you can
choose to have one or the other, or both if you're really dumb.

Alvaro Herrera                      
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?


Reply via email to