cdbi,pgsql & transactions

[prev] [thread] [next] [Date index for 2005/02/09]

hi,

I get error like the following :

DBD::Pg::st execute failed: ERROR: current transaction is aborted, commands ignored until end of transaction block ..

This happen when "do_add" script is executed and there is error in the generated SQL and I try to open again "add"-script 
(not back button).
As I read in the docs AutoCommit is 0 for PostgreSQL, so probaly that is the reason for this 'stalling'.

How to solve this problem ? Probably to put at the start of every script a code to check if there is still
some transaction in the middle and rollback it !? or I have to do it in different way..

tia.