Re: [ADMIN] FATAL: invalid value for parameter "TimeZone" afterupgrade from 9.2 to 9.6

Поиск
Список
Период
Сортировка
От Don Seiler
Тема Re: [ADMIN] FATAL: invalid value for parameter "TimeZone" afterupgrade from 9.2 to 9.6
Дата
Msg-id CAHJZqBC9h+kVLvTt4rkEbEHDjv-Jk6-w6GO3z_nEpKqdY3-66Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [ADMIN] FATAL: invalid value for parameter "TimeZone" afterupgrade from 9.2 to 9.6  (Don Seiler <don@seiler.us>)
Ответы Re: [ADMIN] FATAL: invalid value for parameter "TimeZone" afterupgrade from 9.2 to 9.6  (Don Seiler <don@seiler.us>)
Список pgsql-admin
Дерево обсуждения
On Fri, Nov 17, 2017 at 10:31 AM, Don Seiler <don@seiler.us> wrote:
My working guess right now is that the older JDBC was ignoring that user.timezone parameter when the connection was made. Would be interested in finding out when change happened to confirm.

Looks like this was actually answered in that other thread:

> I ask because a look at the PG JDBC code shows this, which did not 
> show up until Sept 22, 2011. Not sure what release, but it looks like 
> 9.2+: 
> 
> // Construct and send a startup packet. 
>             String[][] params = { 
>                                     { "user", user }, 
>                                     { "database", database }, 
>                                     { "client_encoding", "UTF8" }, 
>                                     { "DateStyle", "ISO" }, 
>                                     { "extra_float_digits", "2" }, 
>                                     { "TimeZone", 
> createPostgresTimeZone() },  

Looks like that is in ConnectionFactoryImpl.java but the current git repo history only goes back to 2015. But at this point I'm satisfied in knowing that upgrading from JDBC 9.1 to a newer JDBC introduced the change we see.

Thanks,
Don.

--
Don Seiler
www.seiler.us

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

Предыдущее
От: Don Seiler
Дата:
Сообщение: Re: [ADMIN] FATAL: invalid value for parameter "TimeZone" afterupgrade from 9.2 to 9.6
Следующее
От: Don Seiler
Дата:
Сообщение: Re: [ADMIN] FATAL: invalid value for parameter "TimeZone" afterupgrade from 9.2 to 9.6