Re: WARNING: 25P01: there is no transaction in progress - Mailing list pgsql-general

From Glyn Astill
Subject Re: WARNING: 25P01: there is no transaction in progress
Date
Msg-id 972965.60892.qm@web23604.mail.ird.yahoo.com
Whole thread Raw
In response to Re: WARNING: 25P01: there is no transaction in progress  (Bill Moran <wmoran@collaborativefusion.com>)
List pgsql-general
> > Ah,
> >
> > It just hit me that I probably logged all the wrong
> type of stuff there. I should have been logging statements
> shouldn't I?
> >
> > http://privatepaste.com/6f1LYISojo
> >
> > I think this shows up that they're sending an
> extra commit transaction on line 36.
> >
> > Could someone do us a favour and check I've not
> misread that?
>
> Looks like it to me.
>
> Notice that they frequently issue two "start
> transaction" in a row.  Seems
> like a flaw in their programming logic somewhere.
>

Yeah I agree, I think they connect into template1 initially and get a list of the databases, then once you choose the
databasetheir software creates another connection to that database, then they issue transaction blocks for every
connection.

A bit mad.




pgsql-general by date:

Previous
From: Glyn Astill
Date:
Subject: Re: WARNING: 25P01: there is no transaction in progress
Next
From: "Dennis Brakhane"
Date:
Subject: Re: WARNING: 25P01: there is no transaction in progress