Thread: Help supressing NOTICE messages

Help supressing NOTICE messages

From
Alex Soto
Date:
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

Re: Help supressing NOTICE messages

From
Devrim GUNDUZ
Date:
-----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-----

Re: Help supressing NOTICE messages

From
Alex Soto
Date:
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:
> -----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-----
>