pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
CONTEXT: in log file 3+ messages / 2 participants [nested] [flat]
* CONTEXT: in log file @ 2004-04-08 11:34 Gaetano Mendola <mendola@bigfoot.com> 2004-04-08 14:19 ` Re: CONTEXT: in log file Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 1 reply; 3+ messages in thread From: Gaetano Mendola @ 2004-04-08 11:34 UTC (permalink / raw) To: pgsql-admin -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi all, using Postgres 7.4.2 I'm seeing in my log file thousand of line with "CONTEXT: " I need to habe the log level debug2, and I'm seeing that the CONTEXT disappear only with: log_min_messages = fatal I think the fatal level is too much in order to remove the CONTEXT information on the log. May I remove the CONTEXT information ? Or at least have the same information on one line. Regards Gaetano Mendola -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.4 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFAdTi87UpzwH2SGd4RAvm7AJ4wyu6RzpjFECclhfE7e59Ej+PvtwCg7Rf5 FaU09BBcDEI3IeQGgVEgznM= =Itgv -----END PGP SIGNATURE----- ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: CONTEXT: in log file 2004-04-08 11:34 CONTEXT: in log file Gaetano Mendola <mendola@bigfoot.com> @ 2004-04-08 14:19 ` Tom Lane <tgl@sss.pgh.pa.us> 2004-04-08 21:15 ` Re: CONTEXT: in log file Gaetano Mendola <mendola@bigfoot.com> 0 siblings, 1 reply; 3+ messages in thread From: Tom Lane @ 2004-04-08 14:19 UTC (permalink / raw) To: Gaetano Mendola <mendola@bigfoot.com>; +Cc: pgsql-admin Gaetano Mendola <mendola@bigfoot.com> writes: > using Postgres 7.4.2 I'm seeing in my log > file thousand of line with "CONTEXT: " Any particular context? > I need to habe the log level debug2, You should hardly gripe about bulkiness of the log in that case... > and I'm seeing that the CONTEXT disappear only with: > log_min_messages = fatal Perhaps log_error_verbosity is what you want to play with. regards, tom lane ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: CONTEXT: in log file 2004-04-08 11:34 CONTEXT: in log file Gaetano Mendola <mendola@bigfoot.com> 2004-04-08 14:19 ` Re: CONTEXT: in log file Tom Lane <tgl@sss.pgh.pa.us> @ 2004-04-08 21:15 ` Gaetano Mendola <mendola@bigfoot.com> 0 siblings, 0 replies; 3+ messages in thread From: Gaetano Mendola @ 2004-04-08 21:15 UTC (permalink / raw) To: Tom Lane <tgl@sss.pgh.pa.us> Tom Lane wrote: > Gaetano Mendola <mendola@bigfoot.com> writes: > >>using Postgres 7.4.2 I'm seeing in my log >>file thousand of line with "CONTEXT: " > > > Any particular context? No just mine own: LOG: statement: select sp_id_admin(); LOG: statement: SELECT id_admin FROM administrators WHERE user_name = current_user CONTEXT: PL/pgSQL function "sp_id_admin" line 4 at select into variables LOG: statement: SELECT NOT $1 CONTEXT: PL/pgSQL function "sp_id_admin" line 8 at if LOG: statement: SELECT $1 so for each select INTO inside my functions I have a CONTECT line >>and I'm seeing that the CONTEXT disappear only with: >>log_min_messages = fatal > > > Perhaps log_error_verbosity is what you want to play with. Yes you're right ( like always ) with log_error_verbosity = terse the CONTEXT line disappeared. Regards Gaetano Mendola ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2004-04-08 21:15 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2004-04-08 11:34 CONTEXT: in log file Gaetano Mendola <mendola@bigfoot.com> 2004-04-08 14:19 ` Re: CONTEXT: in log file Tom Lane <tgl@sss.pgh.pa.us> 2004-04-08 21:15 ` Re: CONTEXT: in log file Gaetano Mendola <mendola@bigfoot.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox