SET TRANSACTION ISOLATION LEVEL

Hi

I got this error, it isn't the first transaction since the server was
started, so I don't understant what it means. The docs seem to suggest
that the READ COMMITTED level is default. If there is a default, why do I
need to set it?

I am AFAIK running single threaded in my java code, so I don't think I
would be dong two separate transactions in the same connection.

postgres 7.1. and this code involved is to get large objects, so it is
non-auto-commiting.

thanks,
PHilip

java.sql.SQLException: ERROR: SET TRANSACTION ISOLATION LEVEL must be
called be fore any query

at org.postgresql.Connection.ExecSQL(Connection.java:533)
at org.postgresql.Connection.ExecSQL(Connection.java:400)
at
org.postgresql.jdbc2.Connection.doIsolationLevel(Connection.java:412)
at org.postgresql.jdbc2.Connection.commit(Connection.java:226)
...

And from the server log:

NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index 'quit_pkey'
for tab
le 'quit'
ERROR: Relation 'quit' already exists
ERROR: Relation 'plottable_cache_seq' already exists
NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index 'quit_pkey'
for tab
le 'quit'
ERROR: Relation 'quit' already exists
DEBUG: MoveOfflineLogs: remove 0000000C000000E4
pq_flush: send() failed: Broken pipe
pq_recvbuf: unexpected EOF on client connection
DEBUG: MoveOfflineLogs: remove 0000000C000000E5
ERROR: Relation 'event' does not exist
DEBUG: MoveOfflineLogs: remove 0000000C000000E6
NOTICE: BEGIN: already a transaction in progress
ERROR: SET TRANSACTION ISOLATION LEVEL must be called before any query
NOTICE: current transaction is aborted, queries ignored until end of
transactio
n block
NOTICE: current transaction is aborted, queries ignored until end of
transactio
n block
NOTICE: current transaction is aborted, queries ignored until end of
transactio
n block
NOTICE: current transaction is aborted, queries ignored until end of
transactio
n block
NOTICE: current transaction is aborted, queries ignored until end of
transactio
n block
NOTICE: current transaction is aborted, queries ignored until end of
transactio
n block