Re: Problems with protocol V3 after migration to latest driver - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: Problems with protocol V3 after migration to latest driver
Date
Msg-id 417CC468.7030704@opencloud.com
Whole thread Raw
In response to Re: Problems with protocol V3 after migration to latest driver  (Kris Jurka <books@ejurka.com>)
Responses Re: Problems with protocol V3 after migration to latest driver
List pgsql-jdbc
Kris Jurka wrote:

> The first time through it does not fail because the driver
> needs to query the backend to get some setup information for large objects
> which starts a transaction.

Sounds like that is (another) bug .. it should be using the
QUERY_SUPPRESS_BEGIN flag for driver-generated queries to avoid starting
a transaction accidentally. I fixed that in various other places but
didn't think to check the LO code.

Also, any thoughts on making the LO vs. bytea behaviour a separate
option, rather than lumping it in with 7.1 compatibility? It seems quite
possible that you might want to use LOs for get/setBytes() but use the
most up to date driver behaviour elsewhere.

-O

pgsql-jdbc by date:

Previous
From: Markus Schaber
Date:
Subject: Re: Calling functions with smallint fails
Next
From: "Alexey Yudichev"
Date:
Subject: Re: Problems with protocol V3 after migration to latest driver