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 E47819DCCC6 for ; Tue, 10 Jan 2006 11:30:26 -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 23665-04-5 for ; Tue, 10 Jan 2006 11:30:30 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from pjetlic.mobart.hr (pjetlic.mobart.hr [80.80.51.10]) by postgresql.org (Postfix) with ESMTP id D5BA29DCD3F for ; Tue, 10 Jan 2006 09:46:02 -0400 (AST) Received: from localhost (localhost.localdomain [127.0.0.1]) by pjetlic.mobart.hr (Postfix) with ESMTP id 31EFC17A40 for ; Tue, 10 Jan 2006 14:45:54 +0100 (CET) Received: from pjetlic.mobart.hr ([127.0.0.1]) by localhost (pjetlic [127.0.0.1]) (amavisd-new, port 10024) with LMTP id 04018-02 for ; Tue, 10 Jan 2006 14:45:54 +0100 (CET) Received: from mike.mobart.hr (mike.mobart.hr [192.168.10.94]) (using SSLv3 with cipher RC4-MD5 (128/128 bits)) (No client certificate requested) by pjetlic.mobart.hr (Postfix) with ESMTP id 04A1417A30 for ; Tue, 10 Jan 2006 14:45:54 +0100 (CET) Subject: Logging nested function calls... From: Mario Splivalo Reply-To: mario.splivalo@mobart.hr To: pgsql-admin@postgresql.org Content-Type: text/plain Organization: Mob-Art Date: Tue, 10 Jan 2006 14:45:53 +0100 Message-Id: <1136900753.8807.31.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.4.1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by OpenSource AV+AS Mail Server X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.06 required=5 tests=[AWL=0.060] X-Spam-Score: 0.06 X-Spam-Level: X-Archive-Number: 200601/103 X-Sequence-Number: 20191 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."