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

From: Glyn Astill <glynastill(at)yahoo(dot)co(dot)uk>
To: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: WARNING: 25P01: there is no transaction in progress
Date: 2008-10-01 18:23:59
Message-ID: 180878.94468.qm@web23601.mail.ird.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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

Although we do have a connection pool for our clients to connect through, we are not connected through it when we do our conversions. Also the same behaviour occours when connecting to my test setup which doesn't have any connections going through a connection pool.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Glyn Astill 2008-10-01 18:28:11 Re: WARNING: 25P01: there is no transaction in progress
Previous Message Bill Moran 2008-10-01 17:26:28 Re: WARNING: 25P01: there is no transaction in progress