Re: Help supressing NOTICE messages - Mailing list pgsql-general

From Alex Soto
Subject Re: Help supressing NOTICE messages
Date
Msg-id 6e9410f7040907061271883834@mail.gmail.com
Whole thread Raw
In response to Re: Help supressing NOTICE messages  (Devrim GUNDUZ <devrim@gunduz.org>)
List pgsql-general
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-----
>

pgsql-general by date:

Previous
From: Paul Thomas
Date:
Subject: Re: ERROR: canceling query due to user request
Next
From: Dino Vliet
Date:
Subject: error: insert has more expressions than target column