From: Ed Loehr <eloehr@austin.rr.com>
To: Manuel Lemos <mlemos@acm.org>
Cc: Lincoln Yeoh <lylyeoh@mecomb.com>
Cc: tomg@admin.nrnet.org
Cc: pgsql-general@postgresql.org
Subject: Re: Connecting website with SQL-database.....
Date: Mon, 24 Apr 2000 14:10:21 -0500
Message-ID: <39049C1D.64AC33E6@austin.rr.com> (raw)
References: <4183.149T1516T2724477mlemos@acm.org>
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.
Regards,
Ed Loehr
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: eloehr@austin.rr.com, mlemos@acm.org, lylyeoh@mecomb.com, tomg@admin.nrnet.org, pgsql-general@postgresql.org
Subject: Re: Connecting website with SQL-database.....
In-Reply-To: <39049C1D.64AC33E6@austin.rr.com>
* 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