ERROR: SET TRANSACTION ISOLATION LEVEL must be called before any query

Поиск
Список
Период
Сортировка
От David Wall
Тема ERROR: SET TRANSACTION ISOLATION LEVEL must be called before any query
Дата
Msg-id 000c01c0caba$8a3daf00$5a2b7ad8@expertrade.com
обсуждение исходный текст
Список pgsql-general
Дерево обсуждения
When using the latest 7.1 release with JDBC, if I do two "group deletes" (each transaction deletes about 10 messages, which probably translates to deleting 30-40 rows from 3-4 tables on the same connection), I am getting the following errors in my server log.
 
ERROR:  SET TRANSACTION ISOLATION LEVEL must be called before any query
NOTICE:  current transaction is aborted, queries ignored until end of transaction block
I have to kill my client before I can do anything more.
 
David

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: very slow execution of stored procedures
Следующее
От: "David Wall"
Дата:
Сообщение: Re: ERROR: SET TRANSACTION ISOLATION LEVEL must be called before any query