Re: [Re] Re: PREPARE and transactions

Jeroen T. Vermeulen wrote:
> On Sat, Jul 03, 2004 at 11:17:18AM +1200, Oliver Jowett wrote:
> 
> 
>>>So many things are true.  But _not_ doing so also breaks compatibility,
>>>so like I said, there are counterexamples.
>>
>>This is nonsense. Not changing the current behaviour cannot break 
>>compatibility, almost by definition.
> 
>  
> Almost.  But prepared statements can break compatibility with code not
> aware of their existence yet--and in some cases, this does not happen if
> they behave transactionally.  It may not be a big deal, but I'm not
> convinced that the effort of supporting rollbacks in middleware is such
> a big waste of time either.

I stand by my original statement: making no change does not break 
compatibility. Please provide an example of PREPARE/EXECUTE use that 
works under 7.3/7.4 but does not work with current 7.5.

>>Please do take a look. The V3 protocol treats the set of named 
>>statements as part of the connection state, not as anything at the SQL 
>>statement level. There are also named portals to deal with if your issue 
>>is that things shouldn't be named.
> 
>  
> But neither of these pose as SQL statements.  It's the SQL session that
> I'm really worried about.

Parse/Bind/Execute interact with PREPARE/EXECUTE -- they share a 
namespace. Quirky as the current behaviour is, it'd be even quirkier if 
PREPARE/EXECUTE had substantially different semantics to Parse/Bind/Execute.

Please do read the V3 protocol spec: 
http://developer.postgresql.org/docs/postgres/protocol.html

-O