From: | Devrim GUNDUZ <devrim(at)gunduz(dot)org> |
---|---|
To: | Alex Soto <apsoto(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Help supressing NOTICE messages |
Date: | 2004-09-07 11:15:16 |
Message-ID: | Pine.LNX.4.61.0409071411110.12570@emo.org.tr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi,
On Tue, 7 Sep 2004, Alex Soto wrote:
> I'm developing some scripts to create my schema to be run by other
> developers and I'd like to have them not spit out those NOTICE messages
> when you create a table regarding the implicit indexes that are made
> since it just makes it harder to see when there is a real error.
>
> I've tried running psql with the quiet argument, I've set the QUIET
> variable to true and the VERBOSITY level to terse but the NOTICE
> messages still appear(while all other output is supressed).
Is that what you're looking for? :
==============================================================
test=# SHOW client_min_messages ;
client_min_messages
- ---------------------
notice
(1 row)
test=# CREATE TABLE alex (id serial);
NOTICE: CREATE TABLE will create implicit sequence "alex_id_seq" for
"serial" column "alex.id"
CREATE TABLE
test=# SET client_min_messages TO error;
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
SET
test=# CREATE TABLE alex2 (id serial);
CREATE TABLE
==============================================0
The line:
SET client_min_messages TO error;
spits out the NOTICE messages.
Regards,
- --
Devrim GUNDUZ
devrim~gunduz.org devrim.gunduz~linux.org.tr
http://www.tdmsoft.com
http://www.gunduz.org
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)
iD8DBQFBPZhGtl86P3SPfQ4RAolqAKDKkbfwrEA2fgZTT0tfXieTnpAZRQCglicl
ZU38zougu+ke/jIQjmDcec8=
=4/tc
-----END PGP SIGNATURE-----
From | Date | Subject | |
---|---|---|---|
Next Message | Jerome Lyles | 2004-09-07 11:24:38 | Postgresql and scripting |
Previous Message | Devrim GUNDUZ | 2004-09-07 11:07:48 | Re: changing the password of postres |