Re: WARNING: 25P01: there is no transaction in progress

Ah,

It just hit me that I probably logged all the wrong type of stuff there. I should have been logging statements
shouldn'tI? 

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@yahoo.co.uk> wrote:

> From: Glyn Astill <glynastill@yahoo.co.uk>
> Subject: [GENERAL] WARNING:  25P01: there is no transaction in progress
> To: pgsql-general@postgresql.org
> 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@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general