Help supressing NOTICE messages

-----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-----

Thanks,

Still no affect. My particular case is for PRIMARY/FOREIGN KEYS.

If it matters, I'm running the statements within a plpgsql function.

Here is a sample statement
SET client_min_messages TO error;

CREATE TABLE users(
userId INTEGER NOT NULL,
login VARCHAR(25) NOT NULL,
password VARCHAR(32) NOT NULL,
firstName VARCHAR(64),
lastName VARCHAR(64),
email VARCHAR(64),
PRIMARY KEY (userId)
);

And I still see this NOTICE message
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "users_pkey" for
table "users"

On Tue, 7 Sep 2004 14:15:16 +0300 (EEST), Devrim GUNDUZ
<devrim@gunduz.org> wrote: