Proposal to add GUC_REPORT to lc_monetary, lc_numeric and search_path

Поиск
Список
Период
Сортировка
От Dave Cramer
Тема Proposal to add GUC_REPORT to lc_monetary, lc_numeric and search_path
Дата
Msg-id CADK3HHK6RimOQYPDgFWPYWiD5TH_XECgV=yJOv+h9kfzT55P7A@mail.gmail.com
обсуждение исходный текст
Ответы Re: Proposal to add GUC_REPORT to lc_monetary, lc_numeric and search_path  (Shay Rojansky <roji@roji.org>)
Список pgsql-hackers
Hello,

The first 2 lc_monetary and lc_numeric are useful if the client for some reason executes set lc_*. We don't get a report and in many cases can't continue to parse numerics or money.
Now it it possible to get these at startup by issuing show or querying the catalog, but it seems much cleaner to just send them.

The latter is important for similar reasons. JDBC caches prepared statements internally and if the user changes the search path without using setSchema or uses a function to change it then internally it would be necessary to invalidate the cache. Currently if this occurs these statements fail.

This seems like a rather innocuous change as the protocol is not changed, rather the amount of information returned on startup is increased marginally.

I've included the authors of the npgsql and the node drivers in the email for their input.

Dave Cramer

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Dent John
Дата:
Сообщение: Re: [PATCH] get rid of StdRdOptions, use individual binary reloptionsrepresentation for each relation kind instead
Следующее
От: Jose Luis Tallon
Дата:
Сообщение: Re: [PATCH] Implement uuid_version()