AW: [HACKERS] TRANSACTIONS

From: Zeugswetter Andreas SB <ZeugswetterA(at)wien(dot)spardat(dot)at>
To: "'Dmitry Samersoff'" <dms(at)wplus(dot)net>
Cc: "'hackers(at)postgresql(dot)org'" <hackers(at)postgresql(dot)org>
Subject: AW: [HACKERS] TRANSACTIONS
Date: 2000-02-23 08:26:32
Message-ID: 219F68D65015D011A8E000006F8590C604AF7CEF@sdexcsrv1.f000.d0188.sd.spardat.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


> AFAIK, MS Access have no transactions inside it,
> Informix (at least old versions I worked with) always
> perform create,drop, alter object outside transaction
> but IMHO it's not right behavior.

MS Access has transactions and Informix (Version 5.00 - 9.20) performs
create, drop, alter inside the transaction, same as Oracle and DB2.

> I believe postgres's behavior more meaningful,
> but IMHO, this example is quite far from real life.

I am pretty sure that the behavior of the others
is the standard.

What PostgreSQL currently also lacks, to make this really useful
is ANSI SQL SQLSTATE (most others also have an int sqlcode),
so you can decide wether this certain error can be ignored or fixed
inside this transaction.
The string parsing we can do is far from optimal.

Andreas

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Hiroshi Inoue 2000-02-23 08:50:48 RE: [HACKERS] Cache query (PREPARE/EXECUTE)
Previous Message Vladimír Beneš 2000-02-23 07:26:11 Re: [HACKERS] Out of memory problem (forwarded bug report)