From: Manuel Lemos <mlemos@acm.org>
To: Ed Loehr <eloehr@austin.rr.com>
Cc: lylyeoh@mecomb.com
Cc: tomg@admin.nrnet.org
Cc: pgsql-general@postgresql.org
Subject: Re: Connecting website with SQL-database.....
Date: 25 Apr 2000 3:31:0 -0200
Message-ID: <1315.150T22T2112775mlemos@acm.org> (raw)
In-Reply-To: <39049C1D.64AC33E6@austin.rr.com>
Hello Ed,
On 24-Apr-00 17:10:21, you wrote:
>Manuel Lemos wrote:
>>
>> >Plus if you get a warning/error, Postgresql _requires_ you to rollback,
>> >whereas many other databases don't.
>>
>> That's what Metabase expects. When there is an error, you should rollback
>> before exiting a transaction with AutoCommit(Off).
>>
>> I noticed the discussion but I could not quite figure what was the problem.
>The problem on this, from my perspective, is that if you have a transaction
>that consists of 20 queries, and the 14th query fails, then you'd like to
>be able to abort only the *statement*, recovering in the client application
>in whatever way seems appropriate. Automatically *forcing* a rollback
>takes that recovery choice away.
The problem is that PostgreSQL lacks of transactions check points with which
you could do what you want. That doesn't mean that transactions work
differently from other DBMS. There's just only one check point to rollback:
the transaction begining.
Regards,
Manuel Lemos
Web Programming Components using PHP Classes.
Look at: http://phpclasses.UpperDesign.com/?user=mlemos@acm.org
--
E-mail: mlemos@acm.org
URL: http://www.mlemos.e-na.net/
PGP key: http://www.mlemos.e-na.net/ManuelLemos.pgp
--
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: mlemos@acm.org, eloehr@austin.rr.com, lylyeoh@mecomb.com, tomg@admin.nrnet.org, pgsql-general@postgresql.org
Subject: Re: Connecting website with SQL-database.....
In-Reply-To: <1315.150T22T2112775mlemos@acm.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox