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 1midCO-0007GC-LH for pgsql-bugs@arkaria.postgresql.org; Thu, 04 Nov 2021 13:54:36 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1midCN-00037x-JL for pgsql-bugs@arkaria.postgresql.org; Thu, 04 Nov 2021 13:54:35 +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 1mid0K-0003nf-RT for pgsql-bugs@lists.postgresql.org; Thu, 04 Nov 2021 13:42:09 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mid0I-0004Fo-1t for pgsql-bugs@lists.postgresql.org; Thu, 04 Nov 2021 13:42:07 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=P+HdmH1YzSSPm7zL6j7gndF32o+UwJcB49NfPnPFELk=; b=cA68z0Eits8Kw4v8kVOuPXVmdz KLRu7jAYbR3GXcGzEgCKcpCyACJbwxSqrNBN/Y7ybeDJseCS3zt278RZ4SgKsR10dHB6qi/5+WvAZ znBCH9ibrcQl++l0BCiF/DdAqhLXLdxOsBOJs9Rov0YGo7Ju34UraTi5wxro+sALY8CpqidDe7Ydm 4DxgrYPMX1ZZBefsuYWw0xU4OXtvvZwXIkqIF66pLLUkROJBdg6TwfTkJydc4zn7aRdUqZ2Xe11zk vQ28YqtjaOmc1mBl4PpgljJl66Psd22RBFkOJVeZiLvJTBtD68U04OpjArqqHzSgB5iJRl2//l0s5 M78viBtw==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mid0H-0001HY-Le for pgsql-bugs@lists.postgresql.org; Thu, 04 Nov 2021 13:42:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mid0E-0006Nm-Gu for pgsql-bugs@lists.postgresql.org; Thu, 04 Nov 2021 13:42:02 +0000 Content-Type: multipart/mixed; boundary="===============1366697876825522188==" MIME-Version: 1.0 Subject: BUG #17271: Updating enum columns type fails when constraints exist To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: amaury@castordoc.com Reply-To: amaury@castordoc.com, pgsql-bugs@lists.postgresql.org Date: Thu, 04 Nov 2021 13:42:00 +0000 Message-ID: <17271-8b4317357c4991e2@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============1366697876825522188== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzI3MQpMb2dnZWQgYnk6ICAgICAgICAgIEFtYXVyeSBEdW1vdWxpbgpF bWFpbCBhZGRyZXNzOiAgICAgIGFtYXVyeUBjYXN0b3Jkb2MuY29tClBvc3RncmVTUUwgdmVyc2lv bjogMTIuOApPcGVyYXRpbmcgc3lzdGVtOiAgIGFscGluZSAzLjE0IG9uIGRvY2tlciAoaG9zdCBt YWNPcyAxMS42KQpEZXNjcmlwdGlvbjogICAgICAgIAoKRXJyb3IgbWVzc2FnZSB1cG9uIGZhaWx1 cmUNCg0KVGhlIGZvbGxvd2luZyBmYWlscw0KDQpDUkVBVEUgVFlQRSBkaXJlY3Rpb25fc3RhdGUg QVMgRU5VTSgnVVAnLCAnRE9XTicpOw0KQ1JFQVRFIFRBQkxFIGV4YW1wbGUgKGlkIFNFUklBTCBQ UklNQVJZIEtFWSwgZGlyZWN0aW9uIGRpcmVjdGlvbl9zdGF0ZSBOT1QKTlVMTCwgYmVsb3cgQk9P TEVBTiBOT1QgTlVMTCk7DQpBTFRFUiBUQUJMRSBleGFtcGxlIEFERCBDT05TVFJBSU5UIGNrX2V4 YW1wbGVfZGlyZWN0aW9uIENIRUNLICgoZGlyZWN0aW9uID0KJ0RPV04nIEFORCBiZWxvdykgT1Ig KE5PVCBiZWxvdykpOw0KQUxURVIgVFlQRSBkaXJlY3Rpb25fc3RhdGUgUkVOQU1FIFRPIGRpcmVj dGlvbl9zdGF0ZV9vbGQ7DQpDUkVBVEUgVFlQRSBkaXJlY3Rpb25fc3RhdGUgQVMgRU5VTSgnVVAn LCAnRE9XTicsICdVTktOT1dOJyk7DQpBTFRFUiBUQUJMRSBleGFtcGxlIEFMVEVSIENPTFVNTiBk aXJlY3Rpb24gVFlQRSBkaXJlY3Rpb25fc3RhdGUgVVNJTkcKZGlyZWN0aW9uOjp0ZXh0OjpkaXJl Y3Rpb25fc3RhdGU7DQpEUk9QIFRZUEUgZGlyZWN0aW9uX3N0YXRlX29sZA0KDQpXaXRoIGEgc2li eWxsaW4gZXJyb3IgbWVzc2FnZQ0KRVJST1I6ICBvcGVyYXRvciBkb2VzIG5vdCBleGlzdDogZGly ZWN0aW9uX3N0YXRlID0gZGlyZWN0aW9uX3N0YXRlX29sZA0KSElOVDogIE5vIG9wZXJhdG9yIG1h dGNoZXMgdGhlIGdpdmVuIG5hbWUgYW5kIGFyZ3VtZW50IHR5cGVzLiBZb3UgbWlnaHQgbmVlZAp0 byBhZGQgZXhwbGljaXQgdHlwZSBjYXN0cy4NCg0KSWYgd2UgZHJvcCBhbmQgcmVjcmVhdGUgdGhl IGNvbnN0cmFpbnQgaXQgd29ya3MNCg0KQ1JFQVRFIFRZUEUgZGlyZWN0aW9uX3N0YXRlIEFTIEVO VU0oJ1VQJywgJ0RPV04nKTsNCkNSRUFURSBUQUJMRSBleGFtcGxlIChpZCBTRVJJQUwgUFJJTUFS WSBLRVksIGRpcmVjdGlvbiBkaXJlY3Rpb25fc3RhdGUgTk9UCk5VTEwsIGJlbG93IEJPT0xFQU4g Tk9UIE5VTEwpOw0KQUxURVIgVEFCTEUgZXhhbXBsZSBBREQgQ09OU1RSQUlOVCBja19leGFtcGxl X2RpcmVjdGlvbiBDSEVDSyAoKGRpcmVjdGlvbiA9CidET1dOJyBBTkQgYmVsb3cpIE9SIChOT1Qg YmVsb3cpKTsNCkFMVEVSIFRZUEUgZGlyZWN0aW9uX3N0YXRlIFJFTkFNRSBUTyBkaXJlY3Rpb25f c3RhdGVfb2xkOw0KQ1JFQVRFIFRZUEUgZGlyZWN0aW9uX3N0YXRlIEFTIEVOVU0oJ1VQJywgJ0RP V04nLCAnVU5LTk9XTicpOw0KQUxURVIgVEFCTEUgZXhhbXBsZSBEUk9QIENPTlNUUkFJTlQgY2tf ZXhhbXBsZV9kaXJlY3Rpb247DQpBTFRFUiBUQUJMRSBleGFtcGxlIEFMVEVSIENPTFVNTiBkaXJl Y3Rpb24gVFlQRSBkaXJlY3Rpb25fc3RhdGUgVVNJTkcKZGlyZWN0aW9uOjp0ZXh0OjpkaXJlY3Rp b25fc3RhdGU7DQpEUk9QIFRZUEUgZGlyZWN0aW9uX3N0YXRlX29sZA0KQUxURVIgVEFCTEUgZXhh bXBsZSBBREQgQ09OU1RSQUlOVCBja19leGFtcGxlX2RpcmVjdGlvbiBDSEVDSyAoKGRpcmVjdGlv biA9CidET1dOJyBBTkQgYmVsb3cpIE9SIChOT1QgYmVsb3cpKTsKCg== --===============1366697876825522188==--