Postgres Pro
Downloads
Home   >   mailing lists

ERROR: SET TRANSACTION ISOLATION LEVEL must be called before any query - Mailing list pgsql-general

From David Wall
Subject ERROR: SET TRANSACTION ISOLATION LEVEL must be called before any query
Date
Msg-id 000c01c0caba$8a3daf00$5a2b7ad8@expertrade.com
Whole thread Raw
List pgsql-general
Tree view
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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: very slow execution of stored procedures
Next
From: "David Wall"
Date:
Subject: Re: ERROR: SET TRANSACTION ISOLATION LEVEL must be called before any query