> -----Original Message-----
> From: pgsql-odbc-owner@postgresql.org
> [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Tom Lane
> Sent: 22 March 2006 14:54
> To: Bart Samwel
> Cc: Ludek Finstrle; pgsql-odbc@postgresql.org
> Subject: Re: [ODBC] Future development
>
> Bart Samwel <bart@samwel.tk> writes:
> > Ludek Finstrle wrote:
> >> Could you explain me the "Level of rollback on errors"? I
> think that
> >> when programmer doesn't use autocommit mode he want react on errors
> >> himself.
>
> > Like I said in my other message, the 8.01 driver doesn't give me a
> > choice in how to react on errors at all: it forces me to
> rollback the
> > complete transaction. I want to have a choice in that. The
> 7.03 driver
> > allows me to set the "Level of rollback on errors" to
> "Statement", which
> > means that only the failed statement is rolled back, and
> *I* then have
> > the choice of whether I want to rollback the remainder of the
> > transaction as well, or that I want to continue / try
> something else.
>
> Really? Considering that there was no backend support at all
> for such a
> thing back in 7.*, this seems improbable.
Not in the backend, but the ODBC REL-07_03_ENHANCED branch has superior
savepoint support over CVS tip.
Regards, Dave.