Help supressing NOTICE messages

[Alex Soto]

Hi All,

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

I searched the archives and found one post from a developer where he
stated that this is a feature that's been asked for and would be
available in 7.3 and I have 7.4.5.

Other than that I haven't been able to find any documentation or mention of it.

Can anyone point me in the right direction?

Thanks,
Alex

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

[Devrim GUNDUZ]

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

iD8DBQFBPZhGtl86P3SPfQ4RAolqAKDKkbfwrEA2fgZTT0tfXi eTnpAZRQCglicl
ZU38zougu+ke/jIQjmDcec8=
=4/tc
-----END PGP SIGNATURE-----

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

[Alex Soto]

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
<de****@gunduz.org> wrote:

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

iD8DBQFBPZhGtl86P3SPfQ4RAolqAKDKkbfwrEA2fgZTT0tfXi eTnpAZRQCglicl
ZU38zougu+ke/jIQjmDcec8=
=4/tc
-----END PGP SIGNATURE-----

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org