I've gotten back to working on the SQL99 version of updateable views and
I'ld like to confirm my current understanding of the parse tree data
structure.  Is there a debugging-type tool for outputting the parse tree for
a given query?

Eric Nielsen

Fri, 06 Jun 2003 09:57:51 -0400
Eric D Nielsen <nielsene@MIT.EDU>
Debugging tool for viewing parse trees?
Eric D Nielsen <nielsene@MIT.EDU> writes:
> I've gotten back to working on the SQL99 version of updateable views and
> I'ld like to confirm my current understanding of the parse tree data
> structure.  Is there a debugging-type tool for outputting the parse tree for
> a given query?

See debug_print_parse, debug_print_rewritten, debug_print_plan,
debug_pretty_print GUC variables.

			regards, tom lane

Sun, 08 Jun 2003 13:50:29 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: Debugging tool for viewing parse trees? 

Sure, see the debug_ variables in postgresql.conf or via SHOW ALL, and
then set client_log_messages to DEBUG.  Also look at debug_pretty_print.

---------------------------------------------------------------------------

Eric D Nielsen wrote:
> I've gotten back to working on the SQL99 version of updateable views and
> I'ld like to confirm my current understanding of the parse tree data
> structure.  Is there a debugging-type tool for outputting the parse tree for
> a given query?
> 
> Eric Nielsen
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
> 
> http://www.postgresql.org/docs/faqs/FAQ.html
> 

-- 
  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

Sun, 8 Jun 2003 21:24:44 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: Debugging tool for viewing parse trees?