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

From: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
To: DNS <letanloc(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: PGSQL - WARNING: 25P01: there is no transaction in progress
Date: 2007-05-04 14:49:22
Message-ID: 463B47F2.9020602@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Alvaro Herrera 2007-05-04 15:04:29 Re: PGSQL - WARNING: 25P01: there is no transaction in progress
Previous Message DNS 2007-05-04 13:54:23 Re: PGSQL - WARNING: 25P01: there is no transaction in progress