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 9369F9DCA65 for ; Tue, 10 Jan 2006 12:20:54 -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 38102-02-3 for ; Tue, 10 Jan 2006 12:20:52 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.196]) by postgresql.org (Postfix) with ESMTP id 514349DCA55 for ; Tue, 10 Jan 2006 12:20:50 -0400 (AST) Received: by zproxy.gmail.com with SMTP id x3so4337004nzd for ; Tue, 10 Jan 2006 08:20:50 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=qLtsaa/snlLMy5J8HFK98TvAqMt1JKxbRzJ38WuCCwnh7BYvfeO6qQMrkrsERKMXp710CVo5bqqlhNgK5Km4XWlacALHWEed2FSDS5QdfucNxUTVR0oN9rI26CyrSpEPUofOTDcxidncJQqEyFuaiiRNafST8UbicOTMizZIkTg= Received: by 10.64.151.12 with SMTP id y12mr3098454qbd; Tue, 10 Jan 2006 08:20:50 -0800 (PST) Received: by 10.65.189.15 with HTTP; Tue, 10 Jan 2006 08:20:50 -0800 (PST) Message-ID: <9e4684ce0601100820g3f8bfc76l163257a5da7455a3@mail.gmail.com> Date: Tue, 10 Jan 2006 17:20:50 +0100 From: hubert depesz lubaczewski To: mario.splivalo@mobart.hr Subject: Re: Logging nested function calls... Cc: pgsql-admin@postgresql.org In-Reply-To: <1136900753.8807.31.camel@localhost.localdomain> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_32423_30772608.1136910050366" References: <1136900753.8807.31.camel@localhost.localdomain> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.221 required=5 tests=[AWL=0.220, HTML_MESSAGE=0.001] X-Spam-Score: 0.221 X-Spam-Level: X-Archive-Number: 200601/104 X-Sequence-Number: 20192 ------=_Part_32423_30772608.1136910050366 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline On 1/10/06, Mario Splivalo wrote: > > 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? > smiply use: raise log '....' at the beginning of your functions. will work. depesz ------=_Part_32423_30772608.1136910050366 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline On 1/10/06, Mario Splivalo <mario.splivalo@mobart.hr> wrote:
The 'problem' is that, in the log file, I only see the top calling
funct= ion, the one that client called. Is there a way to tell postgres to
log = all the nested functions?

smiply use:
raise lo= g '....'
at the beginning of your functions.
will work.

depesz
------=_Part_32423_30772608.1136910050366--