View Single Post

   
  #1 (permalink)  
Old 04-09-2008, 11:18 PM
Sue Fitt
 
Posts: n/a
Default turning off notices

Hi All,

I'm having trouble with turning off notices. Within psql I use \set VERBOSITY terse, which is fine. However, using psql -c I am having trouble. It seems I should be able to use psql -qc 'mycommand' but I am still getting notices output, e.g.

psql -d combilex -qc 'SELECT * FROM show(1135311);'
NOTICE: phonotactic error, please check transcription
CONTEXT: SQL statement "SELECT etc....

Is there a way to turn these notices off other than reconfiguring the conf file and restarting the database? I am using 8.1.3.

Any help appreciated,
Sue
Reply With Quote