PROPOSAL FE/BE extension to handle IN/OUT parameters - Mailing list pgsql-hackers

From Dave Cramer
Subject PROPOSAL FE/BE extension to handle IN/OUT parameters
Date
Msg-id D492C412-3F99-41A2-AC88-3776866D1DBA@fastcrypt.com
Whole thread Raw
Responses Re: PROPOSAL FE/BE extension to handle IN/OUT parameters
List pgsql-hackers
The current situation with IN/OUT parameters requires that  
considerable juggling is required on the client end to not pass the  
OUT parameters in the query. This could be alleviated by adding two  
messages for stored procedure calls
1) PrepareCall which sent the types, and direction of the parameters
2) BindCall which sends the binds the parameters to the above

While I have this working with the jdbc driver, the problem I foresee  
is that when we do finally implement something like what we have  
above. The current driver will be quite difficult to maintain.

Additionally it will be difficult with the current scheme to return  
out parameters and a result set.

Is it  possible to get this into 8.1, or is this a total non-starter



Dave Cramer
davec@postgresintl.com
www.postgresintl.com
ICQ #14675561
jabber davecramer@jabber.org
ph (519 939 0336 )



pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: PROPOSAL - User's exception in PL/pgSQL
Next
From: Josh Berkus
Date:
Subject: Why is checkpoint so costly?