Re: data doesnt get saved in the database / idle in transaction

Поиск
Список
Период
Сортировка
От Qingqing Zhou
Тема Re: data doesnt get saved in the database / idle in transaction
Дата
Msg-id dvm5sb$qh6$1@news.hub.org
обсуждение исходный текст
Ответ на data doesnt get saved in the database / idle in transaction  ("Ksenia Marasanova" <ksenia.marasanova@gmail.com>)
Ответы Re: data doesnt get saved in the database / idle in transaction  ("Jim C. Nasby" <jnasby@pervasive.com>)
Список pgsql-performance
Дерево обсуждения 
""Ksenia Marasanova"" <ksenia.marasanova@gmail.com> wrote
>
> The application uses persistant database connection, and when i check
> the status of the connection, it shows: "idle in transaction".  I am
> pretty sure that every insert is being committed with explicit
> "commit()" . It always worked before.... weird.
>

Try to use the following command to see what commands reach the server:

    set log_statement = "all";

Regards,
Qingqing

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

Предыдущее
От: "Ksenia Marasanova"
Дата:
Сообщение: data doesnt get saved in the database / idle in transaction
Следующее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: Best OS & Configuration for Dual Xeon w/4GB &