where did debug_print_query go in 7.3???

Started by Joseph Shraibmanover 23 years ago4 messagesgeneral
Jump to latest
#1Joseph Shraibman
jks@selectacast.net

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.

#2Joseph Shraibman
jks@selectacast.net
In reply to: Joseph Shraibman (#1)
Re: where did debug_print_query go in 7.3???

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.

#3Bruce Momjian
bruce@momjian.us
In reply to: Joseph Shraibman (#2)
Re: where did debug_print_query go in 7.3???

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
#4Joseph Shraibman
jks@selectacast.net
In reply to: Bruce Momjian (#3)
Re: where did debug_print_query go in 7.3???

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.