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
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 |