Обсуждение: CONTEXT: in log file
-----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-----
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
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