dbTalk Databases Forums  

psql : how to make it more silent....

comp.databases.postgresql.general comp.databases.postgresql.general


Discuss psql : how to make it more silent.... in the comp.databases.postgresql.general forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Patrick Fiche
 
Posts: n/a

Default psql : how to make it more silent.... - 10-13-2004 , 04:50 AM






Hi,

When I execute a function, I would like psql to show me only RAISE NOTICE
messages but not all function calls....
Indeed, I currently get some messages that I don't care about :


* PL/pgSQL function "adm_user" line 321......
* CONTEXT: SQL query "SELECT....."

Is there a way to get rid of these messages....

Thanks


---------------------------------------------------------------------------
----------------
Patrick Fiche
email : patrick.fiche (AT) aqsacom (DOT) com
tél : 01 69 29 36 18
----------------------------------------------------------------------------
---------------








Protected by Polesoft Lockspam
http://www.polesoft.com/refer.html


Reply With Quote
  #2  
Old   
Gaetano Mendola
 
Posts: n/a

Default Re: psql : how to make it more silent.... - 10-13-2004 , 09:52 AM






Patrick Fiche wrote:
Quote:
Hi,

When I execute a function, I would like psql to show me only RAISE
NOTICE messages but not all function calls....
Indeed, I currently get some messages that I don't care about :


* PL/pgSQL function "adm_user" line 321......
* CONTEXT: SQL query "SELECT....."

Is there a way to get rid of these messages....

modify your log_error_verbosity to "terse"



Regards
Gaetano Mendola


Reply With Quote
  #3  
Old   
David Rysdam
 
Posts: n/a

Default Re: psql : how to make it more silent.... - 10-14-2004 , 10:06 AM



Gaetano Mendola wrote:

Quote:
Patrick Fiche wrote:

Hi,

When I execute a function, I would like psql to show me only RAISE
NOTICE messages but not all function calls....
Indeed, I currently get some messages that I don't care about :


* PL/pgSQL function "adm_user" line 321......
* CONTEXT: SQL query "SELECT....."

Is there a way to get rid of these messages....



modify your log_error_verbosity to "terse"

I can't find anything else on that

http://search.postgresql.org/www.sea...rror_verbosity

and I would like to have psql (optionally?) not even send me NOTICE
messages.

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster



Reply With Quote
  #4  
Old   
Tom Lane
 
Posts: n/a

Default Re: psql : how to make it more silent.... - 10-15-2004 , 09:25 AM



David Rysdam <drysdam (AT) ll (DOT) mit.edu> writes:
Quote:
... I would like to have psql (optionally?) not even send me NOTICE
messages.
Have you looked at client_min_messages?

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html



Reply With Quote
  #5  
Old   
David Rysdam
 
Posts: n/a

Default Re: psql : how to make it more silent.... - 10-15-2004 , 09:43 AM



Tom Lane wrote:

Quote:
David Rysdam <drysdam (AT) ll (DOT) mit.edu> writes:


... I would like to have psql (optionally?) not even send me NOTICE
messages.



Have you looked at client_min_messages?

regards, tom lane




I had not, because I'd never heard of it. Looks like exactly what I
want and what I was suspecting existed, thanks.

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.