On Thu, Aug 11, 2016 at 2:58 PM, Venkata Balaji N <nag1...@gmail.com> wrote:

> On Tue, Aug 9, 2016 at 1:02 AM, Robert Haas <robertmh...@gmail.com> wrote:
>> On Mon, Aug 8, 2016 at 10:10 AM, Rahila Syed <rahilasye...@gmail.com>
>> wrote:
>> > Thank you for inputs everyone.
>> >
>> > The opinions on this thread can be classified into following
>> > 1. Commit
> This makes more sense as the user who is doing it would realise that the
> transaction has been left open.
>> Alternatively, I also think it would be sensible to issue an immediate
>> COMMIT when the autocommit setting is changed from off to on.  That
>> was my first reaction.
> Issuing commit would indicate that, open transactions will be committed
> which is not a good idea in my opinion. If the user is issuing AUTOCOMMIT =
> ON, then it means all the transactions initiated after issuing this must be
> committed, whereas it is committing the previously pending transactions as
> well.

My apologies for confusing statement, correction - i meant, by setting
autocommit=on, committing all the previously open transactions (
transactions opened when autocommit=off) may not be a good idea. What user
meant by autocommit=on is that all the subsequent transactions must be

Venkata B N

Fujitsu Australia

Reply via email to