Re: [HACKERS] Pg default's verbosity?

2012-08-30 Thread Bruce Momjian
On Sun, Jun 17, 2012 at 12:00:20AM -0400, nik9...@gmail.com wrote: I've always used -1-f - file.sql. It is confusing that -1 doesn't warn you when it wont work though. This will be fixed in 9.3 with this commit: commit be690e291d59e8d0c9f4df59abe09f1ff6cc0da9 Author: Robert

Re: [HACKERS] Pg default's verbosity?

2012-07-04 Thread Robert Haas
On Mon, Jul 2, 2012 at 3:47 PM, Robert Haas robertmh...@gmail.com wrote: On Fri, Jun 29, 2012 at 3:07 AM, Bruce Momjian br...@momjian.us wrote: Personally, I'd have no problem with flat-out dropping (not demoting) both of those two specific messages. I seem to recall that Bruce has lobbied

Re: [HACKERS] Pg default's verbosity?

2012-06-29 Thread Bruce Momjian
On Tue, Jun 19, 2012 at 02:15:43AM -0400, Tom Lane wrote: Robert Haas robertmh...@gmail.com writes: 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:

Re: [HACKERS] Pg default's verbosity?

2012-06-20 Thread Peter Eisentraut
On tis, 2012-06-19 at 02:15 -0400, Tom Lane wrote: Robert Haas robertmh...@gmail.com writes: 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:

Re: [HACKERS] Pg default's verbosity?

2012-06-20 Thread Robert Haas
On Wed, Jun 20, 2012 at 11:25 AM, Peter Eisentraut pete...@gmx.net wrote: I don't like these messages any more than the next guy, but why drop only those, and not any of the other NOTICE-level messages?  The meaning of NOTICE is pretty much, if this is the first time you're using PostgreSQL,

Re: [HACKERS] Pg default's verbosity?

2012-06-19 Thread Tom Lane
Robert Haas robertmh...@gmail.com writes: 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

Re: [HACKERS] Pg default's verbosity?

2012-06-19 Thread Martijn van Oosterhout
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

Re: [HACKERS] Pg default's verbosity?

2012-06-19 Thread Fabien COELHO
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

Re: [HACKERS] Pg default's verbosity?

2012-06-19 Thread Robert Haas
On Tue, Jun 19, 2012 at 2:15 AM, Tom Lane t...@sss.pgh.pa.us wrote: Robert Haas robertmh...@gmail.com writes: 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

Re: [HACKERS] Pg default's verbosity?

2012-06-18 Thread Robert Haas
On Sat, Jun 16, 2012 at 2:56 PM, Fabien COELHO coe...@cri.ensmp.fr wrote: The argument for defaulting to NOTICE is the same as it's always been: that those messages are really intended for novices, and a pretty good definition of a novice is somebody who doesn't know how to (or that he should)

Re: [HACKERS] Pg default's verbosity?

2012-06-17 Thread Jeff Janes
On Sat, Jun 16, 2012 at 9:00 PM, nik9...@gmail.com wrote: I've always used -1-f - file.sql. It is confusing that -1 doesn't warn you when it wont work though. Yeah, I just got bitten by that one. Definitely violates the POLA. Cheers, Jeff -- Sent via pgsql-hackers mailing list

[HACKERS] Pg default's verbosity?

2012-06-16 Thread Fabien COELHO
Hello pgdev, (Second attempt) I've conducted a statistical study about PostgreSQL use in OSS. One of the result is that quite a few projects have errors in their SQL setup scripts which lead to some statements to be ignored, typically somme ADD CONSTRAINTS which do not change the database

Re: [HACKERS] Pg default's verbosity?

2012-06-16 Thread Tom Lane
Fabien COELHO coe...@cri.ensmp.fr writes: [ errors in SQL scripts fed to psql are easily missed ] So I would suggest the following todos: 1 - change the default verbosity to warning. The argument for defaulting to NOTICE is the same as it's always been: that those messages are really intended

Re: [HACKERS] Pg default's verbosity?

2012-06-16 Thread Fabien COELHO
Hello Tom, thanks for your answer. So I would suggest the following todos: 1 - change the default verbosity to warning. The argument for defaulting to NOTICE is the same as it's always been: that those messages are really intended for novices, and a pretty good definition of a novice is

Re: [HACKERS] Pg default's verbosity?

2012-06-16 Thread nik9000
I've always used -1-f - file.sql. It is confusing that -1 doesn't warn you when it wont work though. Sent from my iPhone On Jun 16, 2012, at 3:42 AM, Fabien COELHO coe...@cri.ensmp.fr wrote: Hello pgdev, (Second attempt) I've conducted a statistical study about PostgreSQL use in