Re: get/setReadOnly broken if default_transaction_read_only on

Поиск
Список
Период
Сортировка
От Віталій Тимчишин
Тема Re: get/setReadOnly broken if default_transaction_read_only on
Дата
Msg-id CABWW-d3BV-WuTFLSuTA1X_WEPb_e9bCpKX5ZN-jkERY3sTu3kQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: get/setReadOnly broken if default_transaction_read_only on  ("Johann 'Myrkraverk' Oskarsson" <johann@2ndquadrant.com>)
Список pgsql-jdbc
Дерево обсуждения
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 по дате отправления: