Re: pgsql: Set the volatility of the timestamptz version of date_bin() back

2021-09-03 Thread Tom Lane
Alvaro Herrera writes: > On 2021-Sep-03, John Naylor wrote: >> On Fri, Sep 3, 2021 at 1:46 PM Alvaro Herrera >> wrote: >>> These catversion bumps in branch 14 this late in the cycle seem suspect. >>> Didn't we have some hesitation to push multirange unnest around beta2 >>> precisely because of a

Re: pgsql: Set the volatility of the timestamptz version of date_bin() back

2021-09-03 Thread Justin Pryzby
On Fri, Sep 03, 2021 at 01:56:50PM -0400, Alvaro Herrera wrote: > On 2021-Sep-03, John Naylor wrote: > > > On Fri, Sep 3, 2021 at 1:46 PM Alvaro Herrera > > wrote: > > > > > > On 2021-Sep-03, John Naylor wrote: > > > These catversion bumps in branch 14 this late in the cycle seem suspect. > > > D

Re: pgsql: Set the volatility of the timestamptz version of date_bin() back

2021-09-03 Thread Alvaro Herrera
On 2021-Sep-03, John Naylor wrote: > On Fri, Sep 3, 2021 at 1:46 PM Alvaro Herrera > wrote: > > > > On 2021-Sep-03, John Naylor wrote: > > These catversion bumps in branch 14 this late in the cycle seem suspect. > > Didn't we have some hesitation to push multirange unnest around beta2 > > precise

Re: pgsql: Set the volatility of the timestamptz version of date_bin() back

2021-09-03 Thread John Naylor
On Fri, Sep 3, 2021 at 1:46 PM Alvaro Herrera wrote: > > On 2021-Sep-03, John Naylor wrote: > These catversion bumps in branch 14 this late in the cycle seem suspect. > Didn't we have some hesitation to push multirange unnest around beta2 > precisely because of a desire to avoid catversion bumps?

Re: pgsql: Set the volatility of the timestamptz version of date_bin() back

2021-09-03 Thread Alvaro Herrera
On 2021-Sep-03, John Naylor wrote: > Set the volatility of the timestamptz version of date_bin() back to immutable > > 543f36b43d was too hasty in thinking that the volatility of date_bin() > had to match date_trunc(), since only the latter references > session_timezone. > > Bump catversion The