The following bug has been logged online:
Bug reference: 2076
Logged by: Farid Z
Email address: farid@zidsoft.com
PostgreSQL version: 8.1
Operating system: Windows 2000
Description: 8.01.01.00 driver transaction error
Details:
ERROR: current transaction is aborted, commands ignored until end of
transaction block
PostGreSQL ANSI and PostGreSQL Unicode driver 8.01.01.00. On hitting any
errror while in a transaction, the driver issues this error and ignores
subsequent commands until end of the transaction. This error does not
happen with 8.00.01.01 driver, but apparently you can't use the 8.0 driver
with an 8.1 server.
Example, while inside of a transaction an sql insert statement results in an
error due to referential integrity, and all subsequent insert statements are
rejected. ( don't want to rollback or commit until the end )
