WARNING: 25P01: there is no transaction in progress

From: Glyn Astill <glynastill(at)yahoo(dot)co(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: WARNING: 25P01: there is no transaction in progress
Date: 2008-10-01 16:23:04
Message-ID: 733368.7257.qm@web23603.mail.ird.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dennis Brakhane 2008-10-01 16:56:31 Re: WARNING: 25P01: there is no transaction in progress
Previous Message Andreas Kretschmer 2008-10-01 16:16:03 Re: Transactions within a function body