Re: [HACKERS] New SET/autocommit problem

2002-10-22 Thread Sean Chittenden
> > WARNING: COMMIT: no transaction in progress > > > I've got tons of these warnings in my logs... is there a programmatic > > way of determining if the current session is in a transaction? > > Not at present: you have to track it for yourself. One of the > suggestions on the list for the next

Re: [HACKERS] New SET/autocommit problem

2002-10-22 Thread Tom Lane
Sean Chittenden <[EMAIL PROTECTED]> writes: > WARNING: COMMIT: no transaction in progress > I've got tons of these warnings in my logs... is there a programmatic > way of determining if the current session is in a transaction? Not at present: you have to track it for yourself. One of the sugges

Re: [HACKERS] New SET/autocommit problem

2002-10-21 Thread Sean Chittenden
> > WARNING: COMMIT: no transaction in progress > > COMMIT > > > The WARNING happens with SHOW and RESET too. I wonder if we should > > suppress the WARNING of a COMMIT with no statements when autocommit is > > off. > > I don't think so; that will make it quite hard to check whether a >