Re: Roadmap for FE/BE protocol redesign

Ashley Cambrell <ash@freaky-namuh.com>

From: Ashley Cambrell <ash@freaky-namuh.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-hackers@postgreSQL.org, pgsql-interfaces@postgreSQL.org
Date: 2003-03-10T21:37:28Z
Lists: pgsql-hackers
Tom Lane wrote:

>This is an attempt to lay out a road map for updating the frontend/backend
>protocol in 7.4.  I don't at this point want to get into details on any
>one of the TODO items, just get consensus that this is the set of tasks
>to be tackled.  Are there any areas that I've missed (that require
>protocol changes)?
>
>  
>
What about binding variables ala oracle's ociparse -> ocibindbyname -> 
ociexecute -> ocifetch ?  I know you can do most of it via SQL 
(PREPARE/EXECUTE) but you can't do 'RETURN x INTO :x' as it stands.  
This would also get around the problem of getting values from newly 
inserted rows (eg PKs) without resorting to OIDs.  Not entirely a FE/BE 
issue... but worth considering in any redesign.

Ashley Cambrell