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

From: DNS <letanloc(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: PGSQL - WARNING: 25P01: there is no transaction in progress
Date: 2007-05-04 15:35:56
Message-ID: 1178292956.604392.127640@u30g2000hsc.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Thanks alot, log_statement = all shows where come the errors.

On 4 mai, 10:49, hei(dot)(dot)(dot)(at)enterprisedb(dot)com (Heikki Linnakangas) wrote:
> DNS wrote:
> > Even desactivate Auto-vacuum didn't fix my issue. Is there any place
> > where I can see past transactions or transactions in queue that hasn't
> > been processed ?
>
> You could put log_statement = all to your postgresql.conf. That'll log
> every statement sent to the server to the log file.
>
> There's no other way to see past statements from the server side.
> There's no such thing as a queue of transactions.
>
> --
> Heikki Linnakangas
> EnterpriseDB http://www.enterprisedb.com

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2007-05-04 16:24:39 Re: Grantor name gets lost when grantor role dropped
Previous Message Alvaro Herrera 2007-05-04 15:04:29 Re: PGSQL - WARNING: 25P01: there is no transaction in progress