Re: AW: [HACKERS] TRANSACTIONS

From: Mike Mascari <mascarm(at)mascari(dot)com>
To: Dmitry Samersoff <dms(at)wplus(dot)net>
Cc: Zeugswetter Andreas SB <ZeugswetterA(at)wien(dot)spardat(dot)at>, "hackers(at)postgresql(dot)org" <hackers(at)postgreSQL(dot)org>
Subject: Re: AW: [HACKERS] TRANSACTIONS
Date: 2000-02-23 10:53:22
Message-ID: 38B3BC22.BC6AFA31@mascari.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Dmitry Samersoff wrote:
>
> On 23-Feb-2000 Zeugswetter Andreas SB wrote:
> >
> >> 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.
^^^^^^
>
> OK. May be I miss something.

I don't think so. Not with respect to Oracle. Andreas knows that
Oracle implicitly commits your running transaction -- and starts
a new one whenever a DDL statement is encountered. A large
discussion about this arose about 4 months ago...I can't speak
for DB2.

>
> --
> Dmitry Samersoff, dms(at)wplus(dot)net, ICQ:3161705
> http://devnull.wplus.net
> * There will come soft rains ...
>
> ************

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Wim Ceulemans 2000-02-23 11:09:14 Re: [GENERAL] AW: [HACKERS] TRANSACTIONS
Previous Message Alessio Bragadini 2000-02-23 10:43:49 Re: [HACKERS] Big join breaks psql