Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mMDuW-0005bx-OB for pgsql-hackers@arkaria.postgresql.org; Fri, 03 Sep 2021 18:27:32 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mMDuV-0001Jh-GS for pgsql-hackers@arkaria.postgresql.org; Fri, 03 Sep 2021 18:27:31 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mMDuV-0001JZ-4e for pgsql-hackers@lists.postgresql.org; Fri, 03 Sep 2021 18:27:31 +0000 Received: from mail-io1-xd33.google.com ([2607:f8b0:4864:20::d33]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1mMDuR-0005gu-RN for pgsql-hackers@lists.postgresql.org; Fri, 03 Sep 2021 18:27:29 +0000 Received: by mail-io1-xd33.google.com with SMTP id e186so7834805iof.12 for ; Fri, 03 Sep 2021 11:27:27 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=telsasoft-com.20150623.gappssmtp.com; s=20150623; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to:user-agent; bh=bs4SriCJFfRRUu6K14SoNLs+zQcQ+Bj/mpzdVRjKwZk=; b=Hrde04JW3EJJD9G5AzrfnsgVp57D8XZBeftxig9bSD+sKJfZlRARzToK/2Es58vjSs QQUyTuiqueTKDKW6yMFQAHp64qNry2zudzWqqdjKz8XsLI85zRrz53xuhb1+p3aRsmi8 USOSzNEDvXZZHvmGfK2IHVtMz1KCGX29rVudb+eKRXvtoNkrHz9+GTRqgM9/LyaSQkpq JFCjFbAnKhoDRzQRAm/OIN/Q8c4Ls3voJxnY2d1TEoSqBS5nZNES9iA8GAin9vrllU10 s4Vg1NXcSusNNIWQcQizMrQX0lmV6cXZMoHUnS1SFaUSSBQkQQkD+51IGJDRtZR/nxz5 fRjg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:date:from:to:cc:subject:message-id:references :mime-version:content-disposition:in-reply-to:user-agent; bh=bs4SriCJFfRRUu6K14SoNLs+zQcQ+Bj/mpzdVRjKwZk=; b=XXsJcTd7N6owppFNsAs0vVYEuLc4P6zYegRO8mleR1A2ayblq/3Hdb8gWILS6ENmTW 1G8B3Nn1+0LTYWfPM60kHPMMZrrTVh5ULAGD9u0byqdPc4KvUYWjeNC6wKuUPYUndyJL TmztIymr1IYSbMK9Pz7EzzdSWo4zSbCZgBZNNqk0mb0FVGnLpgm/XZAI4xurWttgvN8x 88d0XJWkyGtKA5eiaSWWPiEG6bkvVTsPdrKhociH1UAGIT+8bCTuJo5YTVDYF2iVNjaO N8ORo2q/M4GEP5OwpjPQZQzZZE0U8yPCOF5Q6E2nKmiR889W0o85BpW8mKgZZ/iiFpqh pczw== X-Gm-Message-State: AOAM531zcu2W6fqz5L1VzvFKEpaelF8QK2LlExAt73akpqOcBtDfINQX JTMlCplqMoG4d11Ack551vl0Fg== X-Google-Smtp-Source: ABdhPJzuz+fYjuhS/TVi8mCdYQumk2gSujVU4xU/7zWL1+ESf+2RwuzBzbYMrgEM87czKzrA+Zu4hQ== X-Received: by 2002:a05:6602:1503:: with SMTP id g3mr234616iow.25.1630693646670; Fri, 03 Sep 2021 11:27:26 -0700 (PDT) Received: from pryzbyj.telsasoft (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id h10sm119515ilj.71.2021.09.03.11.27.26 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Fri, 03 Sep 2021 11:27:26 -0700 (PDT) Received: by pryzbyj.telsasoft (Postfix, from userid 1000) id 4348E8017D3; Fri, 3 Sep 2021 13:27:25 -0500 (CDT) Date: Fri, 3 Sep 2021 13:27:25 -0500 From: Justin Pryzby To: Alvaro Herrera Cc: John Naylor , John Naylor , pgsql-hackers@lists.postgresql.org Subject: Re: pgsql: Set the volatility of the timestamptz version of date_bin() back Message-ID: <20210903182725.GZ26465@telsasoft.com> References: <202109031756.d6li4szj5zje@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <202109031756.d6li4szj5zje@alvherre.pgsql> User-Agent: Mutt/1.9.4 (2018-02-28) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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. > > > Didn't we have some hesitation to push multirange unnest around beta2 > > > precisely because of a desire to avoid catversion bumps? > > > > This was for correcting a mistake (although the first commit turned out to > > be a mistake itself), so I understood it to be necessary. > > A crazy idea might have been to return to the original value. +1. I think the catversion usually is always increased even in a "revert", but in this exceptional case [0] it would be nice if beta4/rc1 had the same number as b3. [0] two commits close to each other, with no other catalog changes, and with the specific goal of allowing trivial upgrade from b3. -- Justin