From: | Jose Soares <jose(at)sferacarta(dot)com> |
---|---|
To: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
Cc: | Wim Ceulemans <wim(dot)ceulemans(at)nice(dot)be>, "'general'" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: [GENERAL] AW: [HACKERS] TRANSACTIONS |
Date: | 2000-02-28 08:44:57 |
Message-ID: | 38BA3589.F665A695@sferacarta.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
Peter Eisentraut wrote:
> On Thu, 24 Feb 2000, Jose Soares wrote:
>
> > NOTICE: (transaction aborted): all queries ignored until end of transaction block
> >
> > *ABORT STATE*
>
> > Why PostgreSQL doesn't make an implicit ROLLBACK instead of waitting for a
> > COMMIT/ROLLBACK ?
>
> The PostgreSQL transaction paradigm seems to be that if you explicitly
> start a transaction, you get to explicitly end it. This is of course at
> odds with SQL, but it seems internally consistent to me. I hope that one
> of these days we can offer the other behaviour as well.
>
> > Why PostgreSQL allows a COMMIT in this case ?
>
> Good question. I assume it doesn't actually commit though, does it? I
> think a CHECK_IF_ABORTED (sp?) before calling the commit utility routine
> would be appropriate. Anyone?
>
Seems that PostgreSQL has a basically difference from other databases, it has two
operation modes
"transaction mode" and "non-transaction mode".
If you want initialize a transaction in PostgreSQL you must declare it by using the
BEGIN WORK
statement and an END/ABORT/ROLLBACK/COMMIT statement to terminate the transaction and
switch from "transaction mode" to "non-transaction mode".
The SQL92 doesn't have such statement like BEGIN WORK because when you initialize a
connection to a database you are all the time in transaction mode.
Should it be the real problem with transactions ?
>
> --
> Peter Eisentraut Sernanders vaeg 10:115
> peter_e(at)gmx(dot)net 75262 Uppsala
> http://yi.org/peter-e/ Sweden
>
> ************
--
Jose' Soares
Bologna, Italy Jose(at)sferacarta(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2000-02-28 09:10:26 | Re: open pgsql files (was Re: [GENERAL] Mime-Version: 1.0) |
Previous Message | Lincoln Yeoh | 2000-02-28 03:33:24 | Re: [GENERAL] passing variables in PHP3 |
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Lockhart | 2000-02-28 08:51:50 | Re: [HACKERS] Beta for 4:30AST ... ? |
Previous Message | Jan Wieck | 2000-02-28 08:28:29 | Re: [HACKERS] A further thought on rule string size |