Re: get/setReadOnly broken if default_transaction_read_only on

As for me easier is

SELECT current_setting( 'shared_buffers' ), current_setting(
'data_directory' ), ...
One row and you know which column is which setting.

BTW, Johann (sorry for public, but don't know how to reach you in other
way. Could not send directly to you because of "The error that the other
server returned was: 550 550 <johann(at)2ndquadrant(dot)com>: quota exceeded
(state 13).")

Best regards, Vitalii Tymchyshyn.

2012/6/8 Johann 'Myrkraverk' Oskarsson <johann(at)2ndquadrant(dot)com>

> Craig Ringer <ringerc(at)ringerc(dot)id(dot)au> writes:
>
> > The JDBC driver really needs a way to grab everything it needs to know
> > efficiently during initial connection setup, with some extensibility
> > so connection parameters can specify other things to request and cache
> > when the connection is first established.
>
> Something like
>
> SELECT current_setting( 'shared_buffers' )
> UNION
> SELECT current_setting( 'data_directory' );
>
> for some randomly chosen settings? Of course the query will need to be
> structured with key/values to be useful.
>
>
> --
> Johann Oskarsson http://www.2ndquadrant.com/ |[]
> PostgreSQL Development, 24x7 Support, Training and Services --+--
> |
> Blog: http://my.opera.com/myrkraverk/blog/
>
> --
> Sent via pgsql-jdbc mailing list (pgsql-jdbc(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-jdbc
>

--
Best regards,
Vitalii Tymchyshyn