Tom Lane wrote:
> Patrick Welche <[EMAIL PROTECTED]> writes:
> > ... I was running postmaster -d4, yet the only
> > query I saw was the last LOG one. I pretty sure that I would see all queries
> > with -d3 before..
>
> It looked to me like you were just running with the recently-added
> frill to log only queries that cause errors; which is on by default.
>
> (Looks at code...) Ah. It looks like -d to the postmaster no longer
> means anywhere near what it used to. Bruce --- compare the handling
> of -d in the backend (postgres.c lines 1251ff) with its handling in
> the postmaster (postmaster.c lines 444ff). Big difference. Are we
> going to make these more alike? If so, which one do we like?
I am sorry but I don't understand. They look like they both set
server_min_messages. There was a comment in one that said
client_min_messages but I just fixed that.
--
Bruce Momjian | http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
Index: src/backend/tcop/postgres.c
===================================================================
RCS file: /cvsroot/pgsql-server/src/backend/tcop/postgres.c,v
retrieving revision 1.294
diff -c -c -r1.294 postgres.c
*** src/backend/tcop/postgres.c 25 Sep 2002 20:31:40 -0000 1.294
--- src/backend/tcop/postgres.c 26 Sep 2002 01:57:48 -0000
***************
*** 1258,1267 ****
sprintf(debugstr, "debug%s", optarg);
SetConfigOption("server_min_messages",
debugstr, ctx, gucsource);
pfree(debugstr);
-
/*
* -d is not the same as setting
! * client_min_messages because it
enables other
* output options.
*/
if (atoi(optarg) >= 1)
--- 1258,1266 ----
sprintf(debugstr, "debug%s", optarg);
SetConfigOption("server_min_messages",
debugstr, ctx, gucsource);
pfree(debugstr);
/*
* -d is not the same as setting
! * server_min_messages because it
enables other
* output options.
*/
if (atoi(optarg) >= 1)
***************
*** 1275,1288 ****
if (atoi(optarg) >= 5)
SetConfigOption("debug_print_rewritten", "true", ctx, gucsource);
}
- else
-
- /*
- * -d 0 allows user to prevent
postmaster debug
- * from propagating to backend.
- */
- SetConfigOption("server_min_messages",
"notice",
- ctx,
gucsource);
}
break;
--- 1274,1279 ----
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
