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

Поиск
Список
Период
Сортировка
От DNS
Тема Re: PGSQL - WARNING: 25P01: there is no transaction in progress
Дата
Msg-id 1178292956.604392.127640@u30g2000hsc.googlegroups.com
обсуждение исходный текст
Ответ на Re: PGSQL - WARNING: 25P01: there is no transaction in progress  (Heikki Linnakangas <heikki@enterprisedb.com>)
Список pgsql-bugs
Thanks alot, log_statement = all shows where come the errors.

On 4 mai, 10:49, hei...@enterprisedb.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

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: PGSQL - WARNING: 25P01: there is no transaction in progress
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Grantor name gets lost when grantor role dropped