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

From Tom Lane
Subject Re: PROPOSAL FE/BE extension to handle IN/OUT parameters
Date
Msg-id 17406.1119388484@sss.pgh.pa.us
Whole thread Raw
In response to PROPOSAL FE/BE extension to handle IN/OUT parameters  (Dave Cramer <pg@fastcrypt.com>)
Responses Re: PROPOSAL FE/BE extension to handle IN/OUT parameters
List pgsql-hackers
Dave Cramer <pg@fastcrypt.com> writes:
> 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

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

Changing the protocol is a nonstarter at this late date in the release
cycle.  I previously offered you a hack that would accomplish the same
thing (or at least it looks like the same thing to me): ignore
parameters of type VOID when looking up a function.  Is that unusable
from your end?
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Strange logic for partial index proving
Next
From: Tom Lane
Date:
Subject: Re: Why is checkpoint so costly?