On Wed, Oct 1, 2008 at 6:23 PM, Glyn Astill <[EMAIL PROTECTED]> wrote:
> 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.
Of course their software can't be at fault, as
> > 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
>
> If you're using connection pooling it's possible
> that the a connection
> is getting reused and a commit is happening there.
>
> It's not an uncommon practice to do a rollback when
> first getting a
> shared connection to make sure it's fresh and clean...
That's interesting to hear.
Alth
In response to Glyn Astill <[EMAIL PROTECTED]>:
> 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 transact
On Wed, Oct 1, 2008 at 10:23 AM, Glyn Astill <[EMAIL PROTECTED]> wrote:
> 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 new
> > 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.
>
> Of course their software can't be at fault, as it is
> entirely bug free ;-)
>
> You could turn on statement l
k I've not misread that?
Ta
Glyn
--- On Wed, 1/10/08, Glyn Astill <[EMAIL PROTECTED]> wrote:
> From: Glyn Astill <[EMAIL PROTECTED]>
> Subject: [GENERAL] WARNING: 25P01: there is no transaction in progress
> To: pgsql-general@postgresql.org
> Date: Wednesday, 1 Octo
In response to Glyn Astill <[EMAIL PROTECTED]>:
> 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, afte
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 p