Re: what's the message: CONTEXT: PL/pgSQL function "proc_sub_b" line 7 at assignment

From: Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Cc: Gary Fu <gfu(at)sigmaspace(dot)com>
Subject: Re: what's the message: CONTEXT: PL/pgSQL function "proc_sub_b" line 7 at assignment
Date: 2010-12-30 02:12:36
Message-ID: 201012291812.36899.adrian.klaver@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wednesday 29 December 2010 2:19:40 pm Gary Fu wrote:
> Hi,
>
> Why do I get the message in Subject when I do 'select proc_sub_b()'
> under psql ? If I comment out the RAISE statement in proc_sub_a then I
> don't see the message.
>
> Thanks,
> Gary
>

It is just giving the context for the raising of the INFO notice. You can change
that behavior by changing log_error_verbosity () See here for more detail:
http://www.postgresql.org/docs/9.0/interactive/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHAT

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adarsh Sharma 2010-12-30 04:20:09 Automate Scripts to make for managing Large Database Servers.
Previous Message bricklen 2010-12-30 01:28:11 Re: B-tree + sorting + unique constraint