On Tuesday 10 September 2002 03:53 am, Bruce Momjian wrote:
> Fernando Nasser wrote:
> > I could not find the exact clause that says that in either SQL'92 nor
> > SQL'99, but C.J.Date says (about SQL'92) says that a DISCONNECT would
> > "automatically execute either a ROLLBACK or a COMMIT (it is
> > implementation dependent which)".
> >
> > I guess a GUC variable can be a good idea, for Oracle compatibility
> > purposes. I would make our default different from Oracle's though: if a
> > commit is not received something is wrong, either an user error, some
> > tool error, etc. It sees safer to ROLLBACK. Isn't that what we do if
> > a connection is lost due to a communication error anyway? How can
> > Oracle know that if it got the whole set of commands for the transaction
> > anyway? Isn't there a more specific situation where it does that (the
> > automatic COMMIT)?
> >
> > Anyway, psql can be smarter and ask the user: "There is a transaction in
> > progress, do you want to commit?", what can be done
>
> I agree with Tom. If you are in a multi-statement transaction, then if
> you exit, you exit. I can't understand the logic that would to a commit
> on any type of disconnect.
It is only logic that I choose what's happen when I exit
Autocommit=false have another problem
regards
Haris Peco