Re: EXEC_EVALDEBUG debugging broken?

[Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>]

peter(dot)trautmeier(at)gmx(dot)de writes:
> WARNING:  could not dump unrecognized node type: 404
> ExecQual: qual is (
>    {
>    }
> )

Yeah, that code is toast, we probably ought to remove it.  It hasn't
worked since the changes to make the executor treat plan trees as
read-only.  Making it work would require teaching outfuncs.c how to dump
all the different expression state node types, which seems like more
maintenance effort than is justified for debug support that no one uses.
(Dumping an expression tree over again on each evaluation seems of
pretty questionable usefulness to me anyway.)

I'd suggest using EXPLAIN VERBOSE instead, which will give you
the same printout that this would have given you back when it did
work, but only once instead of over again for each row.

			regards, tom lane