Hi,
my PostgreSQL journey goes on... ;)
This does not work (sql pseudo code):
autocommit off;
-> ok
insert into TABLE values (42, 'foo');
-> Cannot insert a duplicate key into unique index pk_TABLE
insert into TABLE values (43, 'foo');
-> NOTICE: current transaction is aborted, queries ignored
until end of transaction block
How can I prevent PostgreSQL from aborting my transaction, if a simple
SQL error occured? Otherwise one can't do senseful exception handling
with PostgreSQL.
Thanks in advance,
Joern
--
Joern Reder -- Software Development, dimedis GmbH, 50672 Koeln
http://www.dimedis.de/ http://spirit.dimedis.de/
supporting: http://www.zyn.de/ http://www.netcologne.de/~nc-joernre/
CPAN: http://www.perl.com/CPAN/modules/by-module/CIPP/JRED/