Postgres Pro
Downloads
Home   >   mailing lists

Thread: Querytree printing

Querytree printing

From
jwieck@debis.com (Jan Wieck)
Date:
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) #

Re: [HACKERS] Querytree printing

From
Bruce Momjian
Date:
>     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,
Pennsylvania19026

Re: [HACKERS] Querytree printing

From
jwieck@debis.com (Jan Wieck)
Date:
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) #