MIME-Version: 1.0
References: <CABvPt_xtYyvFfyupGn=TXNGnEAFd0m_ARPFpDUWBcn603aM84w@mail.gmail.com>
 <1554256.1729521467@sss.pgh.pa.us> <CABvPt_zjW7oVeYg9SMtYre0cG_Jm_mxPiErZMvf2Eco-hOcDxA@mail.gmail.com>
 <dddad51b-4f53-4baa-be88-822caab9f900@aklaver.com> <CABvPt_z1T=LPoRxC78tixvur9d41az4Ben=FYMp0dsWVf4zWLA@mail.gmail.com>
 <1569732.1729527394@sss.pgh.pa.us> <CABvPt_w=dPVwkn=GSX1CEhSzcPKB4xfSTQ_Zbk57UF+P4WLbsQ@mail.gmail.com>
 <1633229.1729533576@sss.pgh.pa.us>
In-Reply-To: <1633229.1729533576@sss.pgh.pa.us>
Reply-To: zarkonesmall@gmail.com
From: Anatolii Smolianinov <zarkonesmall@gmail.com>
Date: Mon, 21 Oct 2024 20:06:37 +0200
Message-ID: <CABvPt_z6YG9O2JEVpS30L80=MmH-dwe_B119Lt4xzUcU9rb2eQ@mail.gmail.com>
Subject: Re: Timezone: resolve $TZDIR in runtime
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Adrian Klaver <adrian.klaver@aklaver.com>, pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="0000000000003d1e5206250084cb"
Archived-At: <https://www.postgresql.org/message-id/CABvPt_z6YG9O2JEVpS30L80%3DMmH-dwe_B119Lt4xzUcU9rb2eQ%40mail.gmail.com>
Precedence: bulk

--0000000000003d1e5206250084cb
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Ah, I see -- so tzselect uses tzdb distribution too? it is just, tzselect
can alter the timezone database and it looks for TZDIR in some
distributions, however, it is not the source of truth in that sense. I
think I see now why it's not really feasible to make such an adjustment..

Thanks for your help!

On Mon, Oct 21, 2024 at 7:59=E2=80=AFPM Tom Lane <tgl@sss.pgh.pa.us> wrote:

> Anatolii Smolianinov <zarkonesmall@gmail.com> writes:
> > Right, it is not an official standard, but TZDIR appears in tzselect,
> which
> > comes from GNU libc.  https://www.unix.com/man-page/redhat/8/TZSELECT/
>
> No, it comes from the tzdb distribution, which otherwise hard-wires
> a compile-time choice for that directory.  Which is how come no other
> program responds to that environment variable.  So if anything, that's
> precedent for our behavior.
>
>                         regards, tom lane
>

--0000000000003d1e5206250084cb
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>Ah, I see -- so tzselect uses tzdb distribution too? =
it is just, tzselect can alter the timezone database and it looks for TZDIR=
 in some distributions, however, it is not the source of truth in that sens=
e. I think I see now why it&#39;s not really feasible to make such an adjus=
tment..<br></div><div><br></div><div>Thanks for your help! <br></div></div>=
<br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Mon=
, Oct 21, 2024 at 7:59=E2=80=AFPM Tom Lane &lt;<a href=3D"mailto:tgl@sss.pg=
h.pa.us">tgl@sss.pgh.pa.us</a>&gt; wrote:<br></div><blockquote class=3D"gma=
il_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,2=
04,204);padding-left:1ex">Anatolii Smolianinov &lt;<a href=3D"mailto:zarkon=
esmall@gmail.com" target=3D"_blank">zarkonesmall@gmail.com</a>&gt; writes:<=
br>
&gt; Right, it is not an official standard, but TZDIR appears in tzselect, =
which<br>
&gt; comes from GNU libc.=C2=A0 <a href=3D"https://www.unix.com/man-page/re=
dhat/8/TZSELECT/" rel=3D"noreferrer" target=3D"_blank">https://www.unix.com=
/man-page/redhat/8/TZSELECT/</a><br>
<br>
No, it comes from the tzdb distribution, which otherwise hard-wires<br>
a compile-time choice for that directory.=C2=A0 Which is how come no other<=
br>
program responds to that environment variable.=C2=A0 So if anything, that&#=
39;s<br>
precedent for our behavior.<br>
<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 regards, tom lane<br>
</blockquote></div>

--0000000000003d1e5206250084cb--