X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 876D69DC95D for ; Tue, 10 Jan 2006 12:28:49 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 39838-01 for ; Tue, 10 Jan 2006 12:28:48 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by postgresql.org (Postfix) with ESMTP id 904C39DC980 for ; Tue, 10 Jan 2006 12:28:47 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.13.1/8.13.1) with ESMTP id k0AGSlgA003908 for ; Tue, 10 Jan 2006 16:28:47 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.1/8.13.1/Submit) id k0AG3KMm001203 for pgsql-admin@postgresql.org; Tue, 10 Jan 2006 16:03:20 GMT (envelope-from news) From: "codeWarrior" X-Newsgroups: pgsql.admin Subject: Re: Logging nested function calls... Date: Tue, 10 Jan 2006 08:03:39 -0800 Organization: iDynaTECH, Inc. Lines: 35 Message-ID: References: <1136900753.8807.31.camel@localhost.localdomain> Reply-To: "codeWarrior" X-Complaints-To: usenet@news.hub.org X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-RFC2646: Format=Flowed; Original To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=-0.891 required=5 tests=[ALL_TRUSTED=-1.44, FORGED_HOTMAIL_RCVD2=0.549] X-Spam-Score: -0.891 X-Spam-Level: X-Archive-Number: 200601/105 X-Sequence-Number: 20193 What about putting a "RAISE NOTICE" statement inside each of your child functions ? "Mario Splivalo" wrote in message news:1136900753.8807.31.camel@localhost.localdomain... > Dobar dan! (Means 'good day' in Croatian) > > I have a postgres (plpgsql) function that calls other (plpgsql and sql) > functions. Those plpgsql functions then may call other plpsql or sql > functions. > > The 'problem' is that, in the log file, I only see the top calling > function, the one that client called. Is there a way to tell postgres to > log all the nested functions? > > I'm using postgresql 8.1.2. > > Thanks in advance. > > Mike > -- > Mario Splivalo > Mob-Art > mario.splivalo@mobart.hr > > "I can do it quick, I can do it cheap, I can do it well. Pick any two." > > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster >