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 1m6Wpg-0002bO-0h for pgsql-bugs@arkaria.postgresql.org; Thu, 22 Jul 2021 11:25:40 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1m6Wpf-0008W3-20 for pgsql-bugs@arkaria.postgresql.org; Thu, 22 Jul 2021 11:25:39 +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 1m6I3f-0006BA-PB for pgsql-bugs@lists.postgresql.org; Wed, 21 Jul 2021 19:39:08 +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 1m6I3c-0001rm-7S for pgsql-bugs@lists.postgresql.org; Wed, 21 Jul 2021 19:39:06 +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=4XRNmlb262l9TJZHGVB8O+mKE3RG72FCS0H7fUEaeCc=; b=jKfj/Gr3kjPZM9k1ETqW0VXpMy bgOkmhD6CW0w8FgspPkKhyaYqZd8N68PzPQ32hWwnUkwqzPF0NXBhY1diA7i4QaLiznIRdQguDaY5 xP1Vqe0Bm7o0XAqzVMfDtDtpPzAfEgTfAtmRP/RuMjYRCf+7UzUO3U/Uaul8rsGuuw5b+ZXXRuekz NGflltsXPXyoDvNmSjBGtqB7E0CY/ZQDCE/6xGC84n621ebpY889LKlTRGLCpO8pZsnowl3WiSiRF HlqfnF6BUMBpiDuB0UkBXMSkEwOXiR4SUDLrnjZR/37TWYvsNm7wvIFzXgV25M58FbIEJHitu5Peh N3xWvy5Q==; 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 1m6I3b-0000td-Rk for pgsql-bugs@lists.postgresql.org; Wed, 21 Jul 2021 19:39:03 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1m6I3a-0000gs-9g for pgsql-bugs@lists.postgresql.org; Wed, 21 Jul 2021 19:39:02 +0000 Content-Type: multipart/mixed; boundary="===============8885360187594044100==" MIME-Version: 1.0 Subject: BUG #17118: ALTER TABLE doesn't discard redundant UNIQUE constraints as CREATE TABLE will To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: zuberre@gmail.com Reply-To: zuberre@gmail.com, pgsql-bugs@lists.postgresql.org Date: Wed, 21 Jul 2021 19:38:02 +0000 Message-ID: <17118-d0bda327525ae046@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 --===============8885360187594044100== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzExOApMb2dnZWQgYnk6ICAgICAgICAgIFJpY2hhcmQgWnViZXIKRW1h aWwgYWRkcmVzczogICAgICB6dWJlcnJlQGdtYWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246IDEz LjMKT3BlcmF0aW5nIHN5c3RlbTogICBEZWJpYW4gMTMuMy0xLnBnZGcxMDArMSAoRG9ja2VyIElt YWdlKQpEZXNjcmlwdGlvbjogICAgICAgIAoKSGVsbG8sDQoNCkkgaGF2ZSBjcmVhdGVkIGEgdGFi bGUgaW4gYSBmcmVzaCBkYXRhYmFzZSBsaWtlIHNvOg0KDQpDUkVBVEUgVEFCTEUgZm9vICgNCiAg ICBmb29faWQgaW50IE5PVCBOVUxMLA0KICAgIENPTlNUUkFJTlQgZm9vX3BrIFBSSU1BUlkgS0VZ IChmb29faWQpLA0KICAgIENPTlNUUkFJTlQgZm9vX3VxIFVOSVFVRSAoZm9vX2lkKQ0KKTsNCg0K DQpJbiBvcmRlciB0byB2aWV3IHRoZSBpbmRleGVzIGNyZWF0ZWQsIEkgcnVuIHRoZSBmb2xsb3dp bmcgc3RhdGVtZW50Og0KDQpTRUxFQ1QgaWR4LnJlbG5hbWUgQVMgaW5kZXhfbmFtZSwNCiAgICAg ICBpbnNwLm5zcG5hbWUgQVMgaW5kZXhfc2NoZW1hLA0KICAgICAgIHRibC5yZWxuYW1lIEFTIHRh YmxlX25hbWUsDQogICAgICAgdG5zcC5uc3BuYW1lIEFTIHRhYmxlX3NjaGVtYQ0KRlJPTSBwZ19p bmRleCBwZ2kNCiAgSk9JTiBwZ19jbGFzcyBpZHggT04gaWR4Lm9pZCA9IHBnaS5pbmRleHJlbGlk DQogIEpPSU4gcGdfbmFtZXNwYWNlIGluc3AgT04gaW5zcC5vaWQgPSBpZHgucmVsbmFtZXNwYWNl DQogIEpPSU4gcGdfY2xhc3MgdGJsIE9OIHRibC5vaWQgPSBwZ2kuaW5kcmVsaWQNCiAgSk9JTiBw Z19uYW1lc3BhY2UgdG5zcCBPTiB0bnNwLm9pZCA9IHRibC5yZWxuYW1lc3BhY2UNCldIRVJFIHBn aS5pbmRpc3VuaXF1ZSBBTkQgdG5zcC5uc3BuYW1lID0gJ3B1YmxpYyc7DQoNClRoZSBvdXRwdXQg SSBnZXQgaXM6DQoNCiBpbmRleF9uYW1lIHwgaW5kZXhfc2NoZW1hIHwgdGFibGVfbmFtZSB8IHRh YmxlX3NjaGVtYSANCi0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0rLS0t LS0tLS0tLS0tLS0NCiBmb29fcGsgICAgIHwgcHVibGljICAgICAgIHwgZm9vICAgICAgICB8IHB1 YmxpYw0KKDEgcm93KQ0KDQpJJ3ZlIG5vdGVkIHRoYXQgdGhlIGRvY3VtZW50YXRpb24gc3RhdGVz OiAiRWFjaCB1bmlxdWUgY29uc3RyYWludCBzaG91bGQKbmFtZSBhIHNldCBvZiBjb2x1bW5zIHRo YXQgaXMgZGlmZmVyZW50IGZyb20gdGhlIHNldCBvZiBjb2x1bW5zIG5hbWVkIGJ5IGFueQpvdGhl ciB1bmlxdWUgb3IgcHJpbWFyeSBrZXkgY29uc3RyYWludCBkZWZpbmVkIGZvciB0aGUgdGFibGUu IChPdGhlcndpc2UsCnJlZHVuZGFudCB1bmlxdWUgY29uc3RyYWludHMgd2lsbCBiZSBkaXNjYXJk ZWQuKSIuDQoNCkhvd2V2ZXIsIGlmIEkgY3JlYXRlIHRoZSB0YWJsZSBsaWtlIHRoaXMgKGFnYWlu IGluIGEgZnJlc2ggZGF0YWJhc2UpOg0KDQpDUkVBVEUgVEFCTEUgZm9vICgNCglmb29faWQgaW50 IE5PVCBOVUxMLA0KCUNPTlNUUkFJTlQgZm9vX3BrIFBSSU1BUlkgS0VZIChmb29faWQpDQopOw0K DQpBTFRFUiBUQUJMRSBmb28gQUREIENPTlNUUkFJTlQgZm9vX3VxIFVOSVFVRSAoZm9vX2lkKTsN Cg0KYW5kIHRoZW4gYWdhaW4gcXVlcnkgZm9yIHRoZSB1bmlxdWUgaW5kaWNlcyB3aXRoIHRoZSBz dGF0ZW1lbnQgYWJvdmUgSQpnZXQ6DQoNCiBpbmRleF9uYW1lIHwgaW5kZXhfc2NoZW1hIHwgdGFi bGVfbmFtZSB8IHRhYmxlX3NjaGVtYSANCi0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tLSstLS0t LS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0NCiBmb29fcGsgICAgIHwgcHVibGljICAgICAgIHwgZm9v ICAgICAgICB8IHB1YmxpYw0KIGZvb191cSAgICAgfCBwdWJsaWMgICAgICAgfCBmb28gICAgICAg IHwgcHVibGljDQooMiByb3dzKQ0KDQpUaGVyZSBpc24ndCBhbnkgc2ltaWxhciBub3RlIGluIHRo ZSBkb2N1bWVudGF0aW9uIGFib3V0IGRpc2NhcmRpbmcgcmVkdW5kYW50CnVuaXF1ZSBjb25zdHJh aW50cyBvbiBBTFRFUiwgc28gdGhlIGRvY3VtZW50YXRpb24gaXMgY29uc2lzdGVudCB3aXRoClBv c3RncmVzJyBiZWhhdmlvciBoZXJlLiAgVGhhdCBzYWlkLCBJIHdvdWxkIGhhdmUgZXhwZWN0ZWQg dGhlIEFMVEVSIFRBQkxFCnN0YXRlbWVudCB0byBhbHNvIGRyb3AgdGhlIHJlZHVuZGFudCBpbmRl eCBkdWUgdG8gdGhlIHByaW1hcnkga2V5LCB5aWVsZGluZwphbiBpZGVudGljYWwgZGF0YWJhc2Ug c2NoZW1hIHRvIHRoZSBDUkVBVEUgdmVyc2lvbi4NCg0KDQpPUyBpbmZvOg0KU0VMRUNUIHZlcnNp b24oKTsNCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgdmVyc2lvbiAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgIA0KLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tDQogUG9zdGdyZVNRTCAxMy4zIChEZWJpYW4gMTMuMy0xLnBnZGcxMDArMSkgb24g eDg2XzY0LXBjLWxpbnV4LWdudSwgY29tcGlsZWQKYnkgZ2NjIChEZWJpYW4gOC4zLjAtNikgOC4z LjAsIDY0LWJpdA0KKDEgcm93KQ0KTm90ZSBteSB0ZXN0IGRhdGFiYXNlIGlzIHJ1bm5pbmcgdW5k ZXIgZG9ja2VyLCBob3N0ZWQgYnkgYSAyMC4wNCBVYnVudHUgeDg2Cm1hY2hpbmUuDQoNCg0KRm9y IHNvbWUgY29udGV4dCBvbiB3aHkgdGhpcyBtaWdodCBtYXR0ZXIgdG8gYSB1c2VyLCBJIHVzZSBh IFNRTCBnZW5lcmF0aW9uCnByb2dyYW0gKHBnbW9kZWxlcikgYXMgdGhlICJmb250IG9mIHRydXRo IiBmb3IgbXkgc2NoZW1hIGRlc2lnbi4gIFNRTCBnZXRzCmV4cG9ydGVkIGZyb20gdGhlIHRvb2wg YW5kIHRoZW4gY29tcGFyZWQgdG8gYSBzZXJpZXMgb2YgcGF0Y2ggZmlsZXMgdGhhdApzaG91bGQg ZW5kIGluIGFuIGlkZW50aWNhbCBzY2hlbWEgdG8gdGhlIHBnbW9kZWxlciBleHBvcnQuICBJIHV0 aWxpemUgdGhlCm1pZ3JhIHRvb2wgdG8gY29tcGFyZSBkaWZmZXJlbmNlcyBhbmQgcmFpc2UgYSBi dWlsZCBlcnJvciBpZiBhbnkgYXJlIGZvdW5kLiAKSSBoYWQgaW5hZHZlcnRlbnRseSBjcmVhdGVk IGEgcmVkdW5kYW50IGluZGV4IGxpa2UgdGhlIG9uZSBkZXNjcmliZWQgYWJvdmUKaW4gYW4gZWFy bGllciBwYXRjaC4gIE9sZGVyIHZlcnNpb25zIG9mIHBnbW9kZWxlciBhcHBlYXIgdG8gdXNlIHRo ZSBBTFRFUgphcHByb2FjaCB0aHVzIGNyZWF0aW5nIHRoZSByZWR1bmRhbnQgaW5kZXgsIGJ1dCB0 aGUgdG9vbCBub3cgc2ltcGx5IHVzZXMgdGhlCkNSRUFURSBhcHByb2FjaCB3aGljaCBkcm9wcyB0 aGUgcmVkdW5kYW50IGluZGV4LiAgV2hlbiB0aGlzIGlzc3VlIGNyb3BwZWQKdXAsIEkgaGFkIGlu aXRpYWxseSB0aG91Z2h0IGl0IHdhcyBhIG1pZ3JhIGJ1Zy4gIEZvciBteSBvd24gcHVycG9zZXMs IHNpbXBseQpkcm9wcGluZyB0aGUgcmVkdW5kYW50IGNvbnN0cmFpbnQgd2FzIHRoZSB1bHRpbWF0 ZSBzb2x1dGlvbi4gIA0KDQpJIHdhbnRlZCB0byBicmluZyB0aGlzIHRvIHRoZSBhdHRlbnRpb24g b2YgdGhlIGNvbW11bml0eSBpZiBpdCBuZWVkZWQgdG8gYmUKYWRkcmVzc2VkIGZ1cnRoZXIuICBQ ZXJoYXBzIGp1c3QgYSBub3RlIGluIHRoZSBkb2N1bWVudGF0aW9uIHdvdWxkIGJlCmhlbHBmdWwg dG8gc29tZW9uZSBpbiB0aGUgZnV0dXJlIGlmIGl0IGRvZXNuJ3QgbWFrZSBzZW5zZSB0byBjaGFu Z2UgdGhlCmJlaGF2aW9yIG9mIEFMVEVSIFRBQkxFIHRvIG1hdGNoIENSRUFURS4gIE90aGVyd2lz ZSBtYXliZSB0aGlzIG1haWxpbmcgbGlzdAplbnRyeSBjYW4gaGVscCBzb21lb25lIG91dCB3aXRo IGEgc2ltaWxhciBpc3N1ZSBpbiB0aGUgZnV0dXJlLg0KDQoNClRoYW5rcyB0byBhbGwgb2YgeW91 IHdobyB3b3JrIG9uIFBvc3RncmVTUUw7IGl0J3MgYW4gYW1hemluZyBmZWF0IG9mCmVuZ2luZWVy aW5nIGFuZCBhIHBsZWFzdXJlIHRvIHdvcmsgd2l0aCENCg0KVGhhbmtzLA0KUmljaGFyZCBadWJl cgoK --===============8885360187594044100==--