Re: postgres_fdw fails because GMT != UTC

2024-04-19 Thread Tom Lane
Etsuro Fujita writes: > On Thu, Apr 4, 2024 at 3:49 PM Laurenz Albe wrote: >> On Thu, 2024-04-04 at 02:19 -0400, Tom Lane wrote: >>> I am not quite clear on how broken an installation needs to be to >>> reject "UTC" as a time zone setting, except that the breakage cannot >>> be subtle. However,

Re: postgres_fdw fails because GMT != UTC

2024-04-10 Thread Etsuro Fujita
On Thu, Apr 4, 2024 at 3:49 PM Laurenz Albe wrote: > On Thu, 2024-04-04 at 02:19 -0400, Tom Lane wrote: > > > ERROR: invalid value for parameter "TimeZone": "UTC" > > > > I am not quite clear on how broken an installation needs to be to > > reject "UTC" as a time zone setting, except that the

Re: postgres_fdw fails because GMT != UTC

2024-04-04 Thread Daniel Gustafsson
> On 4 Apr 2024, at 08:19, Tom Lane wrote: > > Over at [1] we have a complaint of postgres_fdw failing with > a remote-server error > >> ERROR: invalid value for parameter "TimeZone": "UTC" > > I am not quite clear on how broken an installation needs to be to > reject "UTC" as a time zone

Re: postgres_fdw fails because GMT != UTC

2024-04-04 Thread Laurenz Albe
On Thu, 2024-04-04 at 02:19 -0400, Tom Lane wrote: > > ERROR:  invalid value for parameter "TimeZone": "UTC" > > I am not quite clear on how broken an installation needs to be to > reject "UTC" as a time zone setting, except that the breakage cannot > be subtle.  However, I notice that our code

postgres_fdw fails because GMT != UTC

2024-04-04 Thread Tom Lane
Over at [1] we have a complaint of postgres_fdw failing with a remote-server error > ERROR: invalid value for parameter "TimeZone": "UTC" I am not quite clear on how broken an installation needs to be to reject "UTC" as a time zone setting, except that the breakage cannot be subtle. However, I