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 dous a favour and chack I've not misread that? Ta Glyn --- On Wed, 1/10/08, Glyn Astill <glynastill@xxxxxxxxxxx> wrote: > From: Glyn Astill <glynastill@xxxxxxxxxxx> > Subject: [GENERAL] WARNING: 25P01: there is no transaction in progress > To: pgsql-general@xxxxxxxxxxxxxx > Date: Wednesday, 1 October, 2008, 5:23 PM > Hi Chaps, > > I'm getting the aforementioned warning in my logs from > a closed source piece of software. The software helps us > convert over some old proprietary data files, and it's > basically just done a COPY into a newly created table, after > the warning it then goes on to create some indexes. > > I presume it's issuing some sort of commit or rollback > without a begin, however the programs authors are telling me > that's not the case and their software is not at fault. > > Does anyone know if something else could be causing it? > > I've posted a detailed log here: > > http://privatepaste.com/cb0iywATbd > > .. if someone would be so kind to have a quick look I'd > appreciate it. I've posted everything, so it's about > 1000 lines. The warnings are on lines 459 and 475. > > I've tried to follow the StartTransaction / > Endtransaction lines and I don't think I can see an > error there. Is there a possibility its something in > PortalRunUtility ? > > Thanks > Glyn > > > > > -- > Sent via pgsql-general mailing list > (pgsql-general@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general
