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

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: PGSQL - WARNING: 25P01: there is no transaction in progress
Дата
Msg-id 20070502140235.GJ4585@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: PGSQL - WARNING: 25P01: there is no transaction in progress  (DNS <letanloc@gmail.com>)
Ответы Re: PGSQL - WARNING: 25P01: there is no transaction in progress  (DNS <letanloc@gmail.com>)
Список pgsql-bugs
DNS escribió:
> On 27 avr, 19:17, t...@sss.pgh.pa.us (Tom Lane) wrote:
>
> > This is just a warning, which most likely is there only because somebody
> > typed COMMIT or ABORT unnecessarily.  What problem are you actually having?
>
> No one is working on the database when come up the warning. The
> warning makes us worrier about the database but nothing serious on
> database side.

This is not possible.  The server does not send this message all by
itself.  Maybe the driver or connection pooler you are using is sending
a ROLLBACK command when it connects, to "clear up" the connection or
something like that.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

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

Предыдущее
От: DNS
Дата:
Сообщение: Re: PGSQL - WARNING: 25P01: there is no transaction in progress
Следующее
От: "Dhugael McLean"
Дата:
Сообщение: BUG #3260: Subtracting intervals