Querytree printing

Started by Jan Wieckalmost 27 years ago3 messageshackers
Jump to latest
#1Jan Wieck
JanWieck@Yahoo.com

Who needs the pretty printed output of nodeDisplay() ?

I find the output of nodeToString() much more useful when
debugging the rewrite system (especially when looking at
querytree's resulting from joins with many RTE's, Resdom's,
TLE's plus qual, group by etc. clauses. It's hard to keep
track where I am if the entire tree spans hundreds of lines.

Thus I would like to change the output of -d4 back to that of
nodeToString(). Anyone against?

Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#======================================== jwieck@debis.com (Jan Wieck) #

#2Bruce Momjian
bruce@momjian.us
In reply to: Jan Wieck (#1)
Re: [HACKERS] Querytree printing

Who needs the pretty printed output of nodeDisplay() ?

I find the output of nodeToString() much more useful when
debugging the rewrite system (especially when looking at
querytree's resulting from joins with many RTE's, Resdom's,
TLE's plus qual, group by etc. clauses. It's hard to keep
track where I am if the entire tree spans hundreds of lines.

Thus I would like to change the output of -d4 back to that of
nodeToString(). Anyone against?

I like the long pretty printing, with the indentation. You are
suggesting going to the more compressed format. Can we have -d4 do
compressed printing, and -d5 to pretty printing? That would be good.

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026
#3Jan Wieck
JanWieck@Yahoo.com
In reply to: Bruce Momjian (#2)
Re: [HACKERS] Querytree printing

Bruce Momjian wrote:

Who needs the pretty printed output of nodeDisplay() ?

I find the output of nodeToString() much more useful when
debugging the rewrite system (especially when looking at
querytree's resulting from joins with many RTE's, Resdom's,
TLE's plus qual, group by etc. clauses. It's hard to keep
track where I am if the entire tree spans hundreds of lines.

Thus I would like to change the output of -d4 back to that of
nodeToString(). Anyone against?

I like the long pretty printing, with the indentation. You are
suggesting going to the more compressed format. Can we have -d4 do
compressed printing, and -d5 to pretty printing? That would be good.

Yepp - that's the right solution. Done soon!

Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#======================================== jwieck@debis.com (Jan Wieck) #