Postgres Pro
Downloads
Home   >   mailing lists

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

From Віталій Тимчишин
Subject Re: get/setReadOnly broken if default_transaction_read_only on
Date
Msg-id CABWW-d3BV-WuTFLSuTA1X_WEPb_e9bCpKX5ZN-jkERY3sTu3kQ@mail.gmail.com
Whole thread Raw
In response to Re: get/setReadOnly broken if default_transaction_read_only on  ("Johann 'Myrkraverk' Oskarsson" <johann@2ndquadrant.com>)
List pgsql-jdbc
Tree view
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@2ndquadrant.com>: quota exceeded (state 13).")

Best regards, Vitalii Tymchyshyn.


2012/6/8 Johann 'Myrkraverk' Oskarsson <johann@2ndquadrant.com>
Craig Ringer <ringerc@ringerc.id.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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-jdbc



--
Best regards,
 Vitalii Tymchyshyn

pgsql-jdbc by date:

Previous
From: "Johann 'Myrkraverk' Oskarsson"
Date:
Subject: Re: get/setReadOnly broken if default_transaction_read_only on
Next
From: Vlad Arkhipov
Date:
Subject: Connection.isValid(int timeout) implementation