Most recent driver aborts transaction after one error

Поиск
Список
Период
Сортировка
От Bart Samwel
Тема Most recent driver aborts transaction after one error
Дата
Msg-id 44194B56.5050304@samwel.tk
обсуждение исходный текст
Ответы Re: Most recent driver aborts transaction after one error  (Hiroshi Inoue <inoue@tpf.co.jp>)
Re: Most recent driver aborts transaction after one error  (Ludek Finstrle <luf@pzkagis.cz>)
Список pgsql-odbc
Hi there,

I have just upgraded to PostgreSQL 8.1 and I have encountered the
following problem. When I connect through psqlODBC 8.01.0200 (PostgreSQL
Unicode), a sequence like the following:

    <start a transaction>
    DROP SEQUENCE BAZ;
    SELECT 1;

will give an error on the DROP SEQUENCE:

    "42P01: Error while executing the query;
    ERROR:  sequence "app_bod_seq" does not exist"

and will then give an error on the SELECT 1:

    "25P02: Error while executing the query;
    ERROR:  current transaction is aborted, commands ignored until end of
    transaction block"

When connecting through the psqlODBC 8.00.0102, I do *not* get the
second error. This is, in fact, what I would expect. It is also what
pretty much all other databases do (our application also runs on
Informix, Firebird, Oracle and MS SQL Server, and they all allow failed
commands in transactions without forcing a rollback). And it is what the
8.00.0102 driver did (or appeared to do?). Was this behaviour changed on
purpose, and if so, why? And is there a way to work around it? ;-)

--Bart
[3348]globals.extra_systable_prefixes = 'dd_;'
[3348]aszKey='DSN', value='postgres'
[3348]copyAttributes:
DSN='postgres',server='',dbase='',user='',passwd='xxxxx',port='',sslmode='',onlyread='',conn_settings='',disallow_premature=-1)
[3348]globals.extra_systable_prefixes = 'dd_;'
[3348]globals.extra_systable_prefixes = 'dd_;'


В списке pgsql-odbc по дате отправления:

Предыдущее
От: "Tim Clarke"
Дата:
Сообщение: Re: psqlODBC Unicode 8.01.02.00 Driver "Overflows" On MS-Access
Следующее
От: Antonio Pennino
Дата:
Сообщение: updatable cursors