Re: Psycopg3 fails to resolve 'timezone localtime' on MacOS - Mailing list pgsql-general

From Jerry Sievers
Subject Re: Psycopg3 fails to resolve 'timezone localtime' on MacOS
Date
Msg-id 64199747-6DE1-4CF8-95BE-FA17B4A458C4@comcast.net
Whole thread Raw
In response to Re: Psycopg3 fails to resolve 'timezone localtime' on MacOS  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general

> On May 5, 2022, at 8:29 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> 
> Jerry Sievers <gsievers19@comcast.net> writes:
>> Psycopg3 fails to resolve timezone localtime on MacOS (Catalina).
> 
> I doubt Postgres will accept that zone name anywhere.  It's
> not a standard name as far as the tzdb data set is concerned.
> 
> (Having said that, it's far from clear to me whether this code
> fragment is trying to set the PG server's timezone setting or
> not.  Your issue may be purely a Python one.)
> 
> Yep, understood.

Well the setting seems to be permitted for versions < 14.

Er, and we've got hundreds of them config'd as such presently.

More work to do.

I'm still curious though why it stopped working for Psycopg3.

Thx
>             regards, tom lane
> 
> 




pgsql-general by date:

Previous
From: Daniele Varrazzo
Date:
Subject: Re: Psycopg3 fails to resolve 'timezone localtime' on MacOS
Next
From: Jerry Sievers
Date:
Subject: Re: Psycopg3 fails to resolve 'timezone localtime' on MacOS