[pgadmin-support] Strange behaviour concerning SAVEPOINTs

2015-12-18 Thread Frank Gard
Hi, using psql or a programming language API (such as Perl's DBD::Pg), errors (EXCEPTIONs) lead to a "ROLLBACK TO" the last SAVEPOINT, if any. Using pgAdminIII, EXCEPTIONs cause a (full) ROLLBACK, discarding all uncommitted changes. I used the following sequence of SQL statements and a current ver

Re: [pgadmin-support] Strange behaviour concerning SAVEPOINTs

2015-12-18 Thread Frank Gard
Dear Ashesh, thank you very much for this and your instant reply. Indeed, this was my mistake of category "layer-8" :) . Thanks a lot again and best regards, Frank. Am 18.12.2015 um 17:51 schrieb Ashesh Vashi: > Is the AutoRollback checked in SQL Editor Query menu? > > -- > > Thanks & Regards