Re: patches for items from TODO list - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: patches for items from TODO list
Date
Msg-id 428EBB9F.1040807@familyhealth.com.au
Whole thread Raw
In response to Re: patches for items from TODO list  (Josh Berkus <josh@agliodbs.com>)
Responses Re: patches for items from TODO list
List pgsql-hackers
> I'm going to second Neil here.   This feature becomes useful *only* when there 
> is a certified or de-facto universal standard XML representation for database 
> data.   Then I could see a case for it.  But there isn't.   

We've done it in phpPgAdmin (we made up our own standard), and a couple 
of people use it.  I also do not think that it should be in the backend 
until there is a standard.  Here is what phpPgAdmin produces (note NULL 
handling):

<?xml version="1.0" encoding="UTF-8" ?>
<data><header>    <column name="feature_id" type="varchar" />    <column name="feature_name" type="varchar" />
<columnname="is_supported" type="varchar" />    <column name="is_verified_by" type="varchar" />    <column
name="comments"type="varchar" /></header><records>    <row>        <column name="feature_id">PKG000</column>
<columnname="feature_name">Core</column>        <column name="is_supported">NO</column>        <column
name="is_verified_by"null="null"></column>        <column name="comments" null="null"></column>    </row>    <row>
 <column name="feature_id">PKG001</column>        <column name="feature_name">Enhanced datetime facilities</column>
  <column name="is_supported">YES</column>        <column name="is_verified_by" null="null"></column>        <column
name="comments"null="null"></column>    </row>    <row>        <column name="feature_id">PKG002</column>        <column
name="feature_name">Enhancedintegrity management</column>        <column name="is_supported">NO</column>        <column
name="is_verified_by"null="null"></column>        <column name="comments" null="null"></column>    </row>    <row>
 <column name="feature_id">PKG003</column>        <column name="feature_name">OLAP facilities</column>        <column
name="is_supported">NO</column>       <column name="is_verified_by" null="null"></column>        <column
name="comments"null="null"></column>    </row>    <row>        <column name="feature_id">PKG004</column>        <column
name="feature_name">PSM</column>       <column name="is_supported">NO</column>        <column name="is_verified_by"
null="null"></column>       <column name="comments">PL/pgSQL is similar.</column>    </row>    <row>        <column
name="feature_id">PKG005</column>       <column name="feature_name">CLI</column>        <column
name="is_supported">NO</column>       <column name="is_verified_by" null="null"></column>        <column
name="comments">ODBCis similar.</column>    </row>    <row>        <column name="feature_id">PKG006</column>
<columnname="feature_name">Basic object support</column>        <column name="is_supported">NO</column>        <column
name="is_verified_by"null="null"></column>        <column name="comments" null="null"></column>    </row>    <row>
 <column name="feature_id">PKG007</column>        <column name="feature_name">Enhanced object support</column>
<columnname="is_supported">NO</column>        <column name="is_verified_by" null="null"></column>        <column
name="comments"null="null"></column>    </row>    <row>        <column name="feature_id">PKG008</column>        <column
name="feature_name">Activedatabase</column>        <column name="is_supported">NO</column>        <column
name="is_verified_by"null="null"></column>        <column name="comments" null="null"></column>    </row>    <row>
 <column name="feature_id">PKG010</column>        <column name="feature_name">OLAP</column>        <column
name="is_supported">NO</column>       <column name="is_verified_by" null="null"></column>        <column
name="comments">NO</column>   </row></records>
 
</data>


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: patches for items from TODO list
Next
From: Andrew Dunstan
Date:
Subject: Re: patches for items from TODO list