Re: V3 protocol vs INSERT/UPDATE RETURNING

Sorry, copied to list.

On 8/11/06, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> 3. Throw an error (thereby rolling back the incomplete update)
> if client closes the portal without having run it to completion.

Sounds like the most reasonable considering.  I'm not averse to it.

> 4. Treat PORTAL_ONE_RETURNING like PORTAL_UTIL_SELECT rather than
> like PORTAL_ONE_SELECT; that is, execute the query to completion
> on first call and stash the results in a tuplestore until the
> client fetches them.

I agree that it's inefficient, but am trying to think of any other
positive reasons for doing #4 instead.  Can you think of any other
advantages system-wide to using #4 instead of #3?

-- 
Jonah H. Harris, Software Architect | phone: 732.331.1300
EnterpriseDB Corporation            | fax: 732.331.1301
33 Wood Ave S, 2nd Floor            | jharris@enterprisedb.com
Iselin, New Jersey 08830            | http://www.enterprisedb.com/