Re: PostgreSQL and SOAP, suggestions? - Mailing list pgsql-hackers
From | Andrew Dunstan |
---|---|
Subject | Re: PostgreSQL and SOAP, suggestions? |
Date | |
Msg-id | 004501c2f879$be9d0d10$1a01000a@rduadunstan2 Whole thread Raw |
In response to | Re: PostgreSQL and SOAP, suggestions? (Hannu Krosing <hannu@tm.ee>) |
Responses |
Re: PostgreSQL and SOAP, suggestions?
Re: PostgreSQL and SOAP, suggestions? |
List | pgsql-hackers |
I can certainly imagine cases for processing where having the field names and other metadata up front (maybe add type info, nullable, etc instead of just "undefined") would be useful. here's another question: If the intention is to use field names as (local) tag names, how will you handle the case where the field name isn't a valid XML name? Of course, one could do some sort of mapping (replace illegal chars with "_", for example) but then you can't be 100% certain that you haven't generated a collision, I should think. andrew ----- Original Message ----- From: "Steve Wampler" <swampler@noao.edu> To: "mlw" <pgsql@mohawksoft.com> Cc: "Hannu Krosing" <hannu@tm.ee>; <jfelice@cronosys.com>; "Postgres-hackers" <pgsql-hackers@postgresql.org> Sent: Tuesday, April 01, 2003 12:40 PM Subject: Re: [HACKERS] PostgreSQL and SOAP, suggestions? > Out of curiousity, what is the purpose of putting the qry:ROWSET > description into the message at all (header or not)? Isn't it a > perfectly valid SOAP message (and just as parseable) with that removed? > > I freely admit to not being a soap expert, but similar SOAP > messages I generate from queries seem to work fine without this > metadata. Is having it required by some part of the SOAP spec > I don't understand? > > Thanks! > > On Tue, 2003-04-01 at 05:29, mlw wrote: > > > That was part of the same bug as above, it now outputs this: > > > > <?xml version = "1.0"?> > > <mwssql:Envelope xmlns:mwssql="http://www.mohawksoft.com/mwssql/envelope"> > > <mwssql:Header> > > <exec:sql>update cgrpairs set ratio=0 where srcitem=100098670</exec:sql> > > <exec:affected>2657</exec:affected> > > <qry:sql>select * from ztitles limit 2</qry:sql> > > <qry:ROWSET> > > <qry:ROW columns="28"> > > <t:acd>undefined</t:acd> > > <t:muzenbr>undefined</t:muzenbr> > > <t:cat2>undefined</t:cat2> > > <t:cat3>undefined</t:cat3> > > <t:cat4>undefined</t:cat4> > > <t:performer>undefined</t:performer> > > <t:performer2>undefined</t:performer2> > > <t:title>undefined</t:title> > > <t:artist1>undefined</t:artist1> > > <t:engineer>undefined</t:engineer> > > <t:producer>undefined</t:producer> > > <t:labelname>undefined</t:labelname> > > <t:catalog>undefined</t:catalog> > > <t:distribut>undefined</t:distribut> > > <t:released>undefined</t:released> > > <t:origrel>undefined</t:origrel> > > <t:nbrdiscs>undefined</t:nbrdiscs> > > <t:spar>undefined</t:spar> > > <t:minutes>undefined</t:minutes> > > <t:seconds>undefined</t:seconds> > > <t:monostereo>undefined</t:monostereo> > > <t:studiolive>undefined</t:studiolive> > > <t:available>undefined</t:available> > > <t:previews>undefined</t:previews> > > <t:pnotes>undefined</t:pnotes> > > <t:artistid>undefined</t:artistid> > > <t:datasrc>undefined</t:datasrc> > > <t:extid>undefined</t:extid> > > </qry:ROW> > > </qry:ROWSET> > > </mwssql:Header> > > <mwssql:Body> > > <ROWSET columns="28" rows="2"> > > <ROW ROWID="0"> > > <acd>P</acd> > > <muzenbr>68291</muzenbr> > > <cat2>Performer</cat2> > > <cat3>Jazz Instrument</cat3> > > <cat4>Guitar</cat4> > > <performer>Steve Khan</performer> > > <performer2>Khan, Steve</performer2> > > <title>Evidence</title> > > <artist1></artist1> > > <engineer></engineer> > > <producer></producer> > > <labelname>Novus</labelname> > > <catalog>3074</catalog> > > <distribut>BMG</distribut> > > <released>02/13/1990</released> > > <origrel>n/a</origrel> > > <nbrdiscs>1</nbrdiscs> > > <spar>n/a</spar> > > <minutes></minutes> > > <seconds></seconds> > > <monostereo>Stereo</monostereo> > > <studiolive>Studio</studiolive> > > <available>N</available> > > <previews></previews> > > <pnotes></pnotes> > > <artistid>100025343</artistid> > > <datasrc>1</datasrc> > > <extid>68291</extid> > > </ROW> > > <ROW ROWID="1"> > > <acd>P</acd> > > <muzenbr>67655</muzenbr> > > <cat2>Collection</cat2> > > <cat3>Jazz Instrument</cat3> > > <cat4></cat4> > > <performer>Various Artists</performer> > > <performer2>Various Artists</performer2> > > <title>Metropolitan Opera House Jam Session</title> > > <artist1></artist1> > > <engineer></engineer> > > <producer></producer> > > <labelname>Jazz Anthology</labelname> > > <catalog>550212</catalog> > > <distribut>n/a</distribut> > > <released>1992</released> > > <origrel>n/a</origrel> > > <nbrdiscs>1</nbrdiscs> > > <spar>n/a</spar> > > <minutes></minutes> > > <seconds></seconds> > > <monostereo>Mono</monostereo> > > <studiolive>Live</studiolive> > > <available>N</available> > > <previews></previews> > > <pnotes></pnotes> > > <artistid>100050450</artistid> > > <datasrc>1</datasrc> > > <extid>67655</extid> > > </ROW> > > </ROWSET> > > </mwssql:Body> > > </mwssql:Envelope> > --
pgsql-hackers by date: