Re: [HACKERS] PostgreSQL and SOAP, suggestions?

2003-04-03 Thread Hannu Krosing
[EMAIL PROTECTED] kirjutas N, 03.04.2003 kell 02:01: mlw wrote: I think you are interpreting the spec a bit too restrictively. The syntax is fairly rigid, but the spec has a great degree of flexibility. I agree that, syntactically, it must work through a parser, but there is lots of

Re: [HACKERS] PostgreSQL and SOAP, suggestions?

2003-04-03 Thread mlw
Hannu Krosing wrote: [EMAIL PROTECTED] kirjutas N, 03.04.2003 kell 02:01: mlw wrote: I think you are interpreting the spec a bit too restrictively. The syntax is fairly rigid, but the spec has a great degree of flexibility. I agree that, syntactically, it must work through a parser,

Re: [HACKERS] PostgreSQL and SOAP, suggestions?

2003-04-03 Thread cbbrowne
[EMAIL PROTECTED] kirjutas N, 03.04.2003 kell 02:01: mlw wrote: I think you are interpreting the spec a bit too restrictively. The syntax is fairly rigid, but the spec has a great degree of flexibility. I agree that, syntactically, it must work through a parser, but there is lots

Re: [HACKERS] PostgreSQL and SOAP, suggestions?

2003-04-03 Thread cbbrowne
I have been planning to test the whole thing with a few .NET applications. I am currently using expat to parse the output to ensure that it all works correcty. That, unfortunately, probably implies that your implementation is almost totally non-interoperable. You should put out of your

Re: [HACKERS] PostgreSQL and SOAP, suggestions?

2003-04-03 Thread Jason M. Felice
On Thu, Apr 03, 2003 at 07:54:13AM -0500, [EMAIL PROTECTED] wrote: I have been planning to test the whole thing with a few .NET applications. I am currently using expat to parse the output to ensure that it all works correcty. That, unfortunately, probably implies that your

Re: [HACKERS] PostgreSQL and SOAP, suggestions?

2003-04-02 Thread Hannu Krosing
mlw kirjutas T, 01.04.2003 kell 15:29: Hannu Krosing wrote: [EMAIL PROTECTED] kirjutas E, 31.03.2003 kell 19:52: Actually, as far as I am aware, the header is for metadata, i.e. it is the place to describe the data being returned. Did you read the SOAP spec ? yes ???

Re: [HACKERS] PostgreSQL and SOAP, suggestions?

2003-04-02 Thread mlw
Hannu Krosing wrote: mlw kirjutas T, 01.04.2003 kell 15:29: Hannu Krosing wrote: [EMAIL PROTECTED] kirjutas E, 31.03.2003 kell 19:52: Actually, as far as I am aware, the header is for metadata, i.e. it is the place to describe the data being returned. Did you read

Re: [HACKERS] PostgreSQL and SOAP, suggestions?

2003-04-02 Thread Peter Eisentraut
Andrew Dunstan writes: 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

Re: [HACKERS] PostgreSQL and SOAP, suggestions?

2003-04-02 Thread Peter Eisentraut
mlw writes: That function looks great, but what happens if you need to return 1 million records? The same thing that happens with any set-returning function: memory exhaustion. I have an actual libpq program which performs a query against a server, and will stream out the XML, so the number

Re: [HACKERS] PostgreSQL and SOAP, suggestions?

2003-04-02 Thread Hannu Krosing
mlw kirjutas K, 02.04.2003 kell 15:56: Hannu Krosing wrote: What you have come up with _is_not_ a SOAP v1.1 message at all. It does use some elements with similar names but from different namespace. the SOAP Envelope, Header and Body elemants must be from namespace

Re: [HACKERS] PostgreSQL and SOAP, suggestions?

2003-04-02 Thread mlw
Hannu Krosing wrote: mlw kirjutas K, 02.04.2003 kell 15:56: Hannu Krosing wrote: What you have come up with _is_not_ a SOAP v1.1 message at all. It does use some elements with similar names but from different namespace. the SOAP Envelope, Header and Body elemants must be from namespace

Re: [HACKERS] PostgreSQL and SOAP, suggestions?

2003-04-02 Thread cbbrowne
mlw wrote: I think you are interpreting the spec a bit too restrictively. The syntax is fairly rigid, but the spec has a great degree of flexibility. I agree that, syntactically, it must work through a parser, but there is lots of room to be flexible. This is /exactly/ the standard problem

Re: [HACKERS] PostgreSQL and SOAP, suggestions?

2003-04-01 Thread mlw
Hannu Krosing wrote: [EMAIL PROTECTED] kirjutas E, 31.03.2003 kell 19:52: Actually, as far as I am aware, the header is for metadata, i.e. it is the place to describe the data being returned. Did you read the SOAP spec ? yes The description of the fields isn't the actual data

Re: [HACKERS] PostgreSQL and SOAP, suggestions?

2003-04-01 Thread Steve Wampler
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

Re: [HACKERS] PostgreSQL and SOAP, suggestions?

2003-04-01 Thread Andrew Dunstan
PROTECTED] To: mlw [EMAIL PROTECTED] Cc: Hannu Krosing [EMAIL PROTECTED]; [EMAIL PROTECTED]; Postgres-hackers [EMAIL PROTECTED] 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

Re: [HACKERS] PostgreSQL and SOAP, suggestions?

2003-04-01 Thread pgsql
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

Re: [HACKERS] PostgreSQL and SOAP, suggestions?

2003-04-01 Thread Peter Eisentraut
mlw writes: Given a HTTP formatted query: GET http://localhost:8181/pgmuze?query=select+*+from+zsong+limit+2; The output is entered below. That looks a lot like the SQL/XML-style output plus a SOAP header. Below is the output that I get from the SQL/XML function that I wrote. A simple XSLT

Re: [HACKERS] PostgreSQL and SOAP, suggestions?

2003-04-01 Thread mlw
That function looks great, but what happens if you need to return 1 million records? Wouldn't you exhaust all the memory in the server? Or can you stream it somehow? I have an actual libpq program which performs a query against a server, and will stream out the XML, so the number of records

Re: [HACKERS] PostgreSQL and SOAP, suggestions?

2003-03-31 Thread Hannu Krosing
mlw kirjutas E, 31.03.2003 kell 03:43: Given a HTTP formatted query: GET http://localhost:8181/pgmuze?query=select+*+from+zsong+limit+2; The output is entered below. Questions: Is there a way, without spcifying a binary cursor, to get the data types associated with columns? Right now I

Re: [HACKERS] PostgreSQL and SOAP, suggestions?

2003-03-31 Thread pgsql
Actually, as far as I am aware, the header is for metadata, i.e. it is the place to describe the data being returned. The description of the fields isn't the actual data retrieved, so it doesn't belong in the body, so it should go into the header. mlw kirjutas E, 31.03.2003 kell 03:43: Given

Re: [HACKERS] PostgreSQL and SOAP, suggestions?

2003-03-31 Thread Hannu Krosing
[EMAIL PROTECTED] kirjutas E, 31.03.2003 kell 19:52: Actually, as far as I am aware, the header is for metadata, i.e. it is the place to describe the data being returned. Did you read the SOAP spec ? The description of the fields isn't the actual data retrieved, so it doesn't belong in the

Re: [HACKERS] PostgreSQL and SOAP, suggestions?

2003-03-30 Thread mlw
Given a HTTP formatted query: GET http://localhost:8181/pgmuze?query=select+*+from+zsong+limit+2; The output is entered below. Questions: Is there a way, without spcifying a binary cursor, to get the data types associated with columns? Right now I am just using undefined, as the ODBC version