Re: Pg default's verbosity? - Mailing list pgsql-hackers

From Martijn van Oosterhout
Subject Re: Pg default's verbosity?
Date
Msg-id 20120619070705.GA3814@svana.org
Whole thread Raw
In response to Re: Pg default's verbosity?  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
On Mon, Jun 18, 2012 at 09:30:14PM -0400, Robert Haas wrote:
> There might be something to the idea of demoting a few of the things
> we've traditionally had as NOTICEs, though.  IME, the following two
> messages account for a huge percentage of the chatter:
>
> NOTICE:  CREATE TABLE will create implicit sequence "foo_a_seq" for
> serial column "foo.a"
> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
> "foo_pkey" for table "foo"

+1

Absolutely. And if you also suppress the output of the setval's
produced by pg_dump that would make a successful restore of a dump
produce barely any output at all with -q.  That would make errors
significantly more visible.

Not sure how to go about that though.

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> He who writes carelessly confesses thereby at the very outset that he does
> not attach much importance to his own thoughts.  -- Arthur Schopenhauer

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Testing 9.2 in ~production environment
Next
From: Peter Eisentraut
Date:
Subject: Re: Testing 9.2 in ~production environment