X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 9D463D1CCC2 for ; Thu, 8 Apr 2004 18:40:31 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 23551-09 for ; Thu, 8 Apr 2004 18:40:32 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id CD0C8D1CA6C for ; Thu, 8 Apr 2004 18:40:29 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.12.9/8.12.9) with ESMTP id i38LeTT1025801 for ; Thu, 8 Apr 2004 21:40:29 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id i38LFG7m022300 for pgsql-admin@postgresql.org; Thu, 8 Apr 2004 21:15:16 GMT From: Gaetano Mendola X-Newsgroups: comp.databases.postgresql.admin Subject: Re: CONTEXT: in log file Date: Thu, 08 Apr 2004 23:15:17 +0200 Organization: PYRENET Midi-pyrenees Provider Lines: 45 Message-ID: <4075C0E5.9010301@bigfoot.com> References: <407538BE.7020204@bigfoot.com> <13580.1081433956@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: abuse@pyrenet.fr To: Tom Lane User-Agent: Mozilla Thunderbird 0.5 (Windows/20040207) X-Accept-Language: en-us, en In-Reply-To: <13580.1081433956@sss.pgh.pa.us> To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/165 X-Sequence-Number: 13138 Tom Lane wrote: > Gaetano Mendola 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