Re: SQL-Invoked Procedures for 8.1 - Mailing list pgsql-hackers

From Oliver Jowett
Subject Re: SQL-Invoked Procedures for 8.1
Date
Msg-id 41535747.6000603@opencloud.com
Whole thread Raw
In response to Re: SQL-Invoked Procedures for 8.1  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: SQL-Invoked Procedures for 8.1  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane wrote:
> Oliver Jowett <oliver@opencloud.com> writes:
>
>>Tom Lane wrote:
>>
>>>>How can clients distinguish multiple resultsets if they're using the
>>>>extended query protocol?
>>>
>>>You'll get multiple repetitions of RowDescription/DataRows.
>
>
>>Ah, so the Execute spontaneously generates a RowDescription
>>spontaneously when it hits the second resultset, without needing an
>>extra Describe?
>
>
> Oh, wait, you won't get anything.  My example was using simple-Query
> protocol.  In extended Query you get nothing, per this comment in
> pquery.c:

Ok, thanks. It looks like the driver is doing the right thing then.

Here's a one-line patch that clarifies the Execute protocol docs slightly.

-O
Index: doc/src/sgml/protocol.sgml
===================================================================
RCS file: /projects/cvsroot/pgsql-server/doc/src/sgml/protocol.sgml,v
retrieving revision 1.53
diff -u -c -r1.53 protocol.sgml
*** doc/src/sgml/protocol.sgml    16 Aug 2004 02:12:29 -0000    1.53
--- doc/src/sgml/protocol.sgml    23 Sep 2004 23:02:43 -0000
***************
*** 747,753 ****
      The possible
      responses to Execute are the same as those described above for queries
      issued via simple query protocol, except that Execute doesn't cause
!     ReadyForQuery to be issued.
     </para>

     <para>
--- 747,753 ----
      The possible
      responses to Execute are the same as those described above for queries
      issued via simple query protocol, except that Execute doesn't cause
!     ReadyForQuery or RowDescription to be issued.
     </para>

     <para>

pgsql-hackers by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: SQL-Invoked Procedures for 8.1
Next
From: Tom Lane
Date:
Subject: Re: SQL-Invoked Procedures for 8.1