Re: get/setReadOnly broken if default_transaction_read_only on - Mailing list pgsql-jdbc

From Maciek Sakrejda
Subject Re: get/setReadOnly broken if default_transaction_read_only on
Date
Msg-id CAOtHd0CNwWXti=UJXcX4irdyrtVZWWoEuBR7BNqJTJmjfiN8QA@mail.gmail.com
Whole thread Raw
In response to Re: get/setReadOnly broken if default_transaction_read_only on  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: get/setReadOnly broken if default_transaction_read_only on
List pgsql-jdbc
On Fri, Jun 8, 2012 at 6:47 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> There already is a mechanism to notify clients of changes in selected
> GUC settings, but currently the set of parameters so reported is
> hard-wired.  Possibly pgsql-hackers would consider a proposal to let
> the GUC_REPORT flag get set on client-selected parameters.

Somewhat off-topic, but along the same lines, it would also be worth
considering some mechanism to give the driver visibility into catalog
changes w.r.t. UDTs. I.e., right now, the only way for the driver to
sanely support custom types is to query the catalog for the oid of a
specific type name. However, if that type is subsequently dropped and
re-created and gets a different oid, the driver has no idea.
Unfortunately, I don't think there's a great way to support that
without protocol changes (whereas for the reporting flag, that's not
an issue).

pgsql-jdbc by date:

Previous
From: Mike Charnoky
Date:
Subject: Hung JDBC connections
Next
From: Dave Cramer
Date:
Subject: Re: Hung JDBC connections