Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1gjCCU-0001nu-Nd
	for pgsql-hackers@arkaria.postgresql.org; Tue, 15 Jan 2019 00:03:26 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.89)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1gjCCT-00037C-5W
	for pgsql-hackers@arkaria.postgresql.org; Tue, 15 Jan 2019 00:03:25 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <tgl@sss.pgh.pa.us>)
	id 1gjCCS-000375-UW
	for pgsql-hackers@lists.postgresql.org; Tue, 15 Jan 2019 00:03:24 +0000
Received: from sss.pgh.pa.us ([66.207.139.130])
	by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <tgl@sss.pgh.pa.us>)
	id 1gjCCQ-0004RD-TA
	for pgsql-hackers@postgresql.org; Tue, 15 Jan 2019 00:03:24 +0000
Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1])
	by sss.pgh.pa.us (8.14.4/8.14.4) with ESMTP id x0F03AHV030648;
	Mon, 14 Jan 2019 19:03:10 -0500
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Andres Freund <andres@anarazel.de>
cc: Stephen Frost <sfrost@snowman.net>, Simon Riggs <simon@2ndquadrant.com>,
        Robert Haas <robertmhaas@gmail.com>,
        Konstantin Knizhnik <k.knizhnik@postgrespro.ru>,
        Michael Paquier <michael.paquier@gmail.com>,
        Alvaro Herrera <alvherre@alvh.no-ip.org>,
        Christoph Berg <myon@debian.org>,
        Thomas Munro <thomas.munro@enterprisedb.com>,
        Peter Eisentraut <peter.eisentraut@2ndquadrant.com>,
        PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Subject: Re: [HACKERS] Surjective functional indexes
In-reply-to: <20190114235745.quz72yul3hclx3fu@alap3.anarazel.de>
References: <20180511143737.rvogcsxdksrhyyj5@alap3.anarazel.de>
 <CANP8+jLgdS-_ka5bhyG_=f5wGYVY-bQy3YD7rJY=TDnpA1snmg@mail.gmail.com>
 <CA+Tgmob_qk-w38Mbp5wCCGH9G8AFpmB0K0aTLujJqHNbBpBNUA@mail.gmail.com>
 <25975.1541618754@sss.pgh.pa.us>
 <20190114223409.3tcvejfhlvbucrv5@alap3.anarazel.de>
 <28044.1547507004@sss.pgh.pa.us>
 <20190114230918.fhp6wktbhg6pjnyw@alap3.anarazel.de>
 <28651.1547507948@sss.pgh.pa.us> <20190114234617.GW2528@tamriel.snowman.net>
 <30007.1547509982@sss.pgh.pa.us>
 <20190114235745.quz72yul3hclx3fu@alap3.anarazel.de>
Comments: In-reply-to Andres Freund <andres@anarazel.de>
	message dated "Mon, 14 Jan 2019 15:57:45 -0800"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <30646.1547510590.1@sss.pgh.pa.us>
Date: Mon, 14 Jan 2019 19:03:10 -0500
Message-ID: <30647.1547510590@sss.pgh.pa.us>
List-Id: <pgsql-hackers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-hackers@lists.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-hackers>
Precedence: bulk

Andres Freund <andres@anarazel.de> writes:
> On 2019-01-14 18:53:02 -0500, Tom Lane wrote:
>> But I suspect just doing the revert is already going to be painful
>> enough :-(

> I assume you're not particularly interested in doing that?

No, I'm willing to do it, and will do so tomorrow if there haven't
been objections.

What I'm not willing to do is write hacks for pg_upgrade or pg_dump
to mask cases where the option has been set on a v11 index.  I judge
that it's not worth the trouble.  If someone else disagrees, they
can do that work.

			regards, tom lane