From: Andreas Joseph Krogh <andreak@officenet.no>
To: pgsql-sql@postgresql.org
Subject: Re: echo/printf function in plpgsql
Date: Tue, 19 Jul 2005 17:58:05 +0200
Message-ID: <200507191758.05273.andreak@officenet.no> (raw)
In-Reply-To: <42DD19DE.60106@archonet.com>
References: <200507191651.28648.andreak@officenet.no>
<42DD19DE.60106@archonet.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: andreak@officenet.no
Subject: Re: echo/printf function in plpgsql
In-Reply-To: <200507191758.05273.andreak@officenet.no>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox