Skip site navigation (1) Skip section navigation (2)

Re: Quiet "CONTEXT"?

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Mike Toews <mwtoews(at)sfu(dot)ca>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org
Subject: Re: Quiet "CONTEXT"?
Date: 2008-10-28 20:08:36
Message-ID: 20081028200836.GH4912@alvh.no-ip.org (view raw or flat)
Thread:
Lists: pgsql-general
Mike Toews wrote:

> This works perfectly in psql (exactly what I wanted). However, I'm most  
> comfortable using PgAdminIII, and I've tried adding "SET VERBOSITY TO  
> terse;" to either the first command or within the PL/pgSQL function and  
> get the same error:
>
>    unrecognized configuration parameter "verbosity"
>
> Is the feature described above unique only to psql? or how can I modify  
> either the function or PgAdminIII session to achieve the same behaviour?

Error reports are always sent by the server to client in full.  It's up
to the client to do interesting things to them; psql is able to display
it in full, or only the most interesting bits, by changing the
"verbosity", which is what \set does.  This does not change anything in
the server.  This means that if you want pgAdmin to display less of the
message, it's something that pgAdmin must be told to do.  Perhaps having
a less verbose mode is just not implemented, or maybe it's a preference
option you can change.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

In response to

pgsql-general by date

Next:From: aravind chanduDate: 2008-10-28 22:40:45
Subject: Username and Password authentication using pqxx library.
Previous:From: Tom LaneDate: 2008-10-28 20:05:10
Subject: Re: Quiet "CONTEXT"?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group