> And that's also where sending a Query instead of a Sync introduces a > problem: What is supposed to happen if something fails. Let's take the > simple example Bind-Execute-Query: If the Execute causes an error, is > the Query still executed or not? And what about if the Query fails, is > the Execute before committed or rolled back? > > That's why we have the Sync messages, clarify what happens when a > failure occurs somewhere in the pipeline. And only extended protocol > messages are allowed to be part of a pipeline: "Use of the extended > query protocol allows pipelining"
Good point. If we have started extended protocol messages, I think there's no way to avoid the Sync messages before issuing simple protocol messages. Best reagards, -- Tatsuo Ishii SRA OSS LLC English: http://www.sraoss.co.jp/index_en/ Japanese:http://www.sraoss.co.jp