Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qnhX5-00Bhtw-5U for pgsql-committers@arkaria.postgresql.org; Tue, 03 Oct 2023 15:41:59 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qnhX2-006uKl-BS for pgsql-committers@arkaria.postgresql.org; Tue, 03 Oct 2023 15:41:56 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qnhX2-006uKd-3R for pgsql-committers@lists.postgresql.org; Tue, 03 Oct 2023 15:41:56 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qnhWz-00805i-Bh for pgsql-committers@lists.postgresql.org; Tue, 03 Oct 2023 15:41:54 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qnhWy-0004Pm-HJ for pgsql-committers@lists.postgresql.org; Tue, 03 Oct 2023 15:41:52 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qnhWx-007Jz0-RP for pgsql-committers@lists.postgresql.org; Tue, 03 Oct 2023 15:41:51 +0000 Content-Type: multipart/mixed; boundary="===============5584349280913791729==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Add some notes about why "ALTER TYPE enum DROP VALUE" is hard. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Tue, 03 Oct 2023 15:41:51 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============5584349280913791729== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 QWRkIHNvbWUgbm90ZXMgYWJvdXQgd2h5ICJBTFRFUiBUWVBFIGVudW0gRFJPUCBWQUxVRSIgaXMg aGFyZC4KCkluIGhvcGVzIG9mIHB1dHRpbmcgdGhlc2Ugd2hlcmUgYW55IHdvdWxkLWJlIGltcGxl bWVudGVyIGlzIHN1cmUgdG8KZmluZCB0aGVtLCBtYWtlIGEgcGxhY2Vob2xkZXIgZ3JhbW1hciBw cm9kdWN0aW9uIGZvciBBTFRFUiBEUk9QIFZBTFVFCmFuZCBwdXQgdGhlbSB0aGVyZS4gIFRoaXMg aXMgcmVhbGx5IGp1c3QgYSBkb2NzIHBhdGNoLCB0aG91Z2guCgpWaWsgRmVhcmluZywgd2l0aCBh IGJpdCBtb3JlIHdvcmRzbWl0aGluZyBieSBtZQoKRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0Z3Iu ZXMvbS85ZmZmZDE0OS1kYTBmLTBjOWMtNjc0NS03MzFmYjY4ODY0MmFAcG9zdGdyZXNmcmllbmRz Lm9yZwoKQnJhbmNoCi0tLS0tLQptYXN0ZXIKCkRldGFpbHMKLS0tLS0tLQpodHRwczovL2dpdC5w b3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmL2FmM2VlOGEwODZjYTIxMGQ5NDYxZjgxMzUzOGQw MTY5ZGJmMDdjMmMKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0tCnNyYy9iYWNrZW5kL3Bh cnNlci9ncmFtLnkgfCAyNyArKysrKysrKysrKysrKysrKysrKysrKysrKysKMSBmaWxlIGNoYW5n ZWQsIDI3IGluc2VydGlvbnMoKykKCg== --===============5584349280913791729==--