| From: | Glyn Astill <glynastill(at)yahoo(dot)co(dot)uk> |
|---|---|
| To: | Bill Moran <wmoran(at)collaborativefusion(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: WARNING: 25P01: there is no transaction in progress |
| Date: | 2008-10-01 18:28:11 |
| Message-ID: | 972965.60892.qm@web23604.mail.ird.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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 database their software creates another connection to that database, then they issue transaction blocks for every connection.
A bit mad.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gauthier, Dave | 2008-10-01 18:57:53 | Ideas on how to use external perl script |
| Previous Message | Glyn Astill | 2008-10-01 18:23:59 | Re: WARNING: 25P01: there is no transaction in progress |