From: Andreas Joseph Krogh <andreak@officenet.no>
Organization: OfficeNet AS
To: pgsql-sql@postgresql.org
Subject: Re: echo/printf function in plpgsql
Date: Tue, 19 Jul 2005 17:58:05 +0200
User-Agent: KMail/1.7.2
References: <200507191651.28648.andreak@officenet.no>
	<42DD19DE.60106@archonet.com>
In-Reply-To: <42DD19DE.60106@archonet.com>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200507191758.05273.andreak@officenet.no>

On Tuesday 19 July 2005 17:18, Richard Huxton wrote:
> Andreas Joseph Krogh wrote:
> > Hi all!
> >
> > Is there a way of echo'ing a string(like "raise notice 'this is id%',
> > id") from plpgsql? I want to echo/print it to STDOUT 'cause the
> > notice-mechanism produces too much noise IMH.
>
> Your function is running in the backend. You don't have a STDOUT
> (although you might have redirected STDERR for logging).

I see. Can I make the ouput somehow less verbose? It spits out a lot of noise 
for each "NOTICE":
====================
psql:ocs_process_projecct.sql:48: NOTICE:  trying to insert parent_id: 87, 
child_id: 91
CONTEXT:  SQL statement "SELECT  processSubProject( $1 ,  $2 ,  $3 )"
PL/pgSQL function "processsubproject" line 7 at perform
SQL statement "SELECT  processSubProject( $1 ,  $2 ,  $3 )"
PL/pgSQL function "processsubproject" line 7 at perform
SQL statement "SELECT  processSubProject( $1 ,  $2 ,  $3 )"
PL/pgSQL function "build_project_children" line 11 at perform
====================

--
AJk