Re: PostgreSQL and SOAP, suggestions? - Mailing list pgsql-hackers

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>
-- 
Steve Wampler <swampler@noao.edu>
National Solar Observatory