turning off notices

From: "Sue Fitt" <sfitt(at)fittconway(dot)plus(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: turning off notices
Date: 2008-01-19 15:10:33
Message-ID: 008501c85aad$718087f0$0200a8c0@wilfrid
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Hannes Dorbath 2008-01-19 15:21:34 Re: TSearch: CLUSTER using GIST, query using GIN?
Previous Message Oleg Bartunov 2008-01-19 15:10:27 Re: TSearch: CLUSTER using GIST, query using GIN?