Explain XML patch submitted

I just posted a patch addressing the TODO item:

"Allow EXPLAIN output to be more easily processed by scripts, perhaps XML"

This is a modified patch originally submitted by Germán Poó Caamaño
last year. I added the DTD and some other tweaks.

I did *not* delve much into the ecpg code, other than mildly modifying
prepoc.y by adding the XML and DTD defines. I'm sure more work is
required there.

And, I did not include "Init Plan" and "Sub Plan" in the XML output,
which did not fit into the XML in a graceful way. But, that can also
be revisited.

Regards,

Tom Raney

Where are we on this patch?

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

raneyt(at)cecs(dot)pdx(dot)edu wrote:
> I just posted a patch addressing the TODO item:
>
> "Allow EXPLAIN output to be more easily processed by scripts, perhaps XML"
>
> This is a modified patch originally submitted by Germ?n Po? Caama?o
> last year. I added the DTD and some other tweaks.
>
> I did *not* delve much into the ecpg code, other than mildly modifying
> prepoc.y by adding the XML and DTD defines. I'm sure more work is
> required there.
>
> And, I did not include "Init Plan" and "Sub Plan" in the XML output,
> which did not fit into the XML in a graceful way. But, that can also
> be revisited.
>
> Regards,
>
> Tom Raney
>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +

Bruce Momjian wrote:
> Where are we on this patch?
>

I think I submitted the patch before its time. The project opened a big
can of worms with the XML output. I'd like to rework it with some of
the comments I received.

The work there was some prep-work for the planner visualizer I've been
working on. I haven't had time to revisit this initial work.

-Tom Raney

> ---------------------------------------------------------------------------
>
> raneyt(at)cecs(dot)pdx(dot)edu wrote:
>
>> I just posted a patch addressing the TODO item:
>>
>> "Allow EXPLAIN output to be more easily processed by scripts, perhaps XML"
>>
>> This is a modified patch originally submitted by Germ?n Po? Caama?o
>> last year. I added the DTD and some other tweaks.
>>
>> I did *not* delve much into the ecpg code, other than mildly modifying
>> prepoc.y by adding the XML and DTD defines. I'm sure more work is
>> required there.
>>
>> And, I did not include "Init Plan" and "Sub Plan" in the XML output,
>> which did not fit into the XML in a graceful way. But, that can also
>> be revisited.
>>
>> Regards,
>>
>> Tom Raney
>>
>> --
>> Sent via pgsql-hackers mailing list (pgsql-hackers(at)postgresql(dot)org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-hackers
>>
>
>