Postgres Pro
Downloads
Home   >   mailing lists

Thread: where did debug_print_query go in 7.3???

where did debug_print_query go in 7.3???

From
Joseph Shraibman
Date:
How come debug_print_query isn't in 7.3??? I need that to develop my application.

Also the docs haven't been fully updated. runtime-config.html has:

DEBUG_PRINT_PARSE (boolean)
DEBUG_PRINT_REWRITTEN (boolean)
DEBUG_PRINT_PLAN (boolean)
DEBUG_PRETTY_PRINT (boolean)

     These flags enable various debugging output to be sent to the server log. For each
executed query, print either the query text, the resulting parse tree, the query rewriter
                                ^^^^^^^^^^^^
output, or the execution plan. DEBUG_PRETTY_PRINT indents these displays to produce a more
readable but much longer output format.

Re: where did debug_print_query go in 7.3???

From
Joseph Shraibman
Date:
Joseph Shraibman wrote:
> How come debug_print_query isn't in 7.3??? I need that to develop my
> application.
>
Nevermind, found it. It was renamed to log_statement. May I suggest that the default
config file have more comments in it?

> Also the docs haven't been fully updated. runtime-config.html has:
>
> DEBUG_PRINT_PARSE (boolean)
> DEBUG_PRINT_REWRITTEN (boolean)
> DEBUG_PRINT_PLAN (boolean)
> DEBUG_PRETTY_PRINT (boolean)
>
>     These flags enable various debugging output to be sent to the server
> log. For each executed query, print either the query text, the resulting
>                                ^^^^^^^^^^^^
Still needs to be fixed.

Re: where did debug_print_query go in 7.3???

From
Bruce Momjian
Date:
Joseph Shraibman wrote:
> Joseph Shraibman wrote:
> > How come debug_print_query isn't in 7.3??? I need that to develop my
> > application.
> >
> Nevermind, found it. It was renamed to log_statement. May I suggest that the default
> config file have more comments in it?

Release notes have info about those changes.  More log_* changes coming
for 7.4, again will be in the release notes.

> > Also the docs haven't been fully updated. runtime-config.html has:
> >
> > DEBUG_PRINT_PARSE (boolean)
> > DEBUG_PRINT_REWRITTEN (boolean)
> > DEBUG_PRINT_PLAN (boolean)
> > DEBUG_PRETTY_PRINT (boolean)
> >
> >     These flags enable various debugging output to be sent to the server
> > log. For each executed query, print either the query text, the resulting
> >                                ^^^^^^^^^^^^
> Still needs to be fixed.

Updated.  Thanks.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Re: where did debug_print_query go in 7.3???

From
Joseph Shraibman
Date:
Bruce Momjian wrote:
> Joseph Shraibman wrote:

> Release notes have info about those changes.  More log_* changes coming
> for 7.4, again will be in the release notes.

Not just for the changes, but in general. At least put in "for details see
doc/html/runtime-config.html". Maybe you will want to generate the entire install path to
the docs at compile time, or point them to the website.