Sqlcancel and commands ignored until end of transaction block

From: "N(dot) Campbell" <the6campbells(at)gmail(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Sqlcancel and commands ignored until end of transaction block
Date: 2014-05-13 11:42:50
Message-ID: 5372053d.a4ea320a.71be.5f55@mx.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Can someone explain why postgres exhibits the following behaviour . dsn has use declare fetch on. Application sets auto commit on and proceeds to prepare, describe , bind and execute a query. While execute is running it calls sqlcancel and will subsequently receive
current transaction is aborted, commands ignored until end of transaction block when it attempts to describe the number of columns on a new statement it prepared on the same connection.

Why can it not continue per other vendors. Why does it do this with sqlcancel yet allows similar sequences where a prepare may have failed or exception is thrown by execute (ie. Div by zero etc).

There seems to be no documentation saying that the handling of sqlcancel is by design and why. Why is this not a design issue which still appears to exist in current 9.x releases.

Seems like a bug to me but many posts found via Google do not appear to clarify design intent, why so and why it had not been changed.

Browse pgsql-odbc by date

  From Date Subject
Next Message Hiroshi Saito 2014-05-13 13:19:33 Re: psqlODBC msi download for Heartbleed
Previous Message Michael Paquier 2014-05-13 10:32:31 Re: psqlODBC msi download for Heartbleed