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 1nKM78-0006jj-Qh for pgsql-bugs@arkaria.postgresql.org; Wed, 16 Feb 2022 15:21:07 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nKM77-0007Ri-FA for pgsql-bugs@arkaria.postgresql.org; Wed, 16 Feb 2022 15:21:05 +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 1nKLSW-000581-U4 for pgsql-bugs@lists.postgresql.org; Wed, 16 Feb 2022 14:39: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 1nKLST-0007ne-GW for pgsql-bugs@lists.postgresql.org; Wed, 16 Feb 2022 14:39: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=fz6UkA+8GJ6aXKQZ/Cby18awRpHeEr64UOTSHaF4WsY=; b=fPK0AAhN/p8ksEzBSPSy8OvrvI kw76ZlCH19DZ1bHQ8Q49hY5Hh5sOG3aq3shRkBXUHFfnPK2f7lhc2c+MJxoFJm5RVtjvbcEhKkZ/k vcpE/WdJ4eWRdQgCuTGirF5bf9a30pNPyh4zltMAEkH+OwBKHgU902nVm8uA79N6kXrqVODUmrPGC UWyb/g7coUBnDmusuc5awwv7aPjFCf7mIM8Kg6Z66P79P8+YsrEa6724kIzua5R+KYifQV6A0w3nq 06zh9mitJsVPupOMewoT6f3xd65mYG4QzIcOaOjI0ZP2gpk40lTgr1WPQgZ2HBAgsJibjQWyGKBCV 3rjWizOA==; 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 1nKLSS-00056J-Lp for pgsql-bugs@lists.postgresql.org; Wed, 16 Feb 2022 14:39:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nKLSQ-0004sa-9R for pgsql-bugs@lists.postgresql.org; Wed, 16 Feb 2022 14:39:02 +0000 Content-Type: multipart/mixed; boundary="===============2538565289280126016==" MIME-Version: 1.0 Subject: BUG #17409: Unable to alter data type of clustered column which is referenced by foreign key To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: holly.roberts@starlingbank.com Reply-To: holly.roberts@starlingbank.com, pgsql-bugs@lists.postgresql.org Date: Wed, 16 Feb 2022 14:38:55 +0000 Message-ID: <17409-52871dda8b5741cb@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 --===============2538565289280126016== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzQwOQpMb2dnZWQgYnk6ICAgICAgICAgIEhvbGx5IFJvYmVydHMKRW1h aWwgYWRkcmVzczogICAgICBob2xseS5yb2JlcnRzQHN0YXJsaW5nYmFuay5jb20KUG9zdGdyZVNR TCB2ZXJzaW9uOiAxNC4yCk9wZXJhdGluZyBzeXN0ZW06ICAgRGViaWFuIDEwLjIuMS02CkRlc2Ny aXB0aW9uOiAgICAgICAgCgpXaGVuIGF0dGVtcHRpbmcgdG8gY2hhbmdlIHRoZSBkYXRhIHR5cGUg b2YgYSBjb2x1bW4gdGhhdCBoYXMgcHJldmlvdXNseSBiZWVuCmNsdXN0ZXJlZCBvbiwgd2hpY2gg aXMgYWxzbyByZWZlcmVuY2VkIGJ5IGEgZm9yZWlnbiBrZXksIHRoZW4gYW4gZXhjZXB0aW9uCmlz IHRocm93bi4NCg0KUmVwcm9kdWN0aW9uIHN0ZXBzIHVzaW5nIGEgZnJlc2ggZGF0YWJhc2U6DQoJ Q1JFQVRFIFRBQkxFIHBhcmVudCAoDQoJCXBhcmVudF9maWVsZCBJTlRFR0VSIENPTlNUUkFJTlQg cGtfcGFyZW50IFBSSU1BUlkgS0VZDQoJKTsNCglDUkVBVEUgVEFCTEUgY2hpbGQgKA0KCQljaGls ZF9maWVsZCBJTlRFR0VSLA0KCQlDT05TVFJBSU5UIGZrX2NoaWxkIEZPUkVJR04gS0VZIChjaGls ZF9maWVsZCkgUkVGRVJFTkNFUyBwYXJlbnQKKHBhcmVudF9maWVsZCkNCgkpOw0KCUNMVVNURVIg cGFyZW50IFVTSU5HIHBrX3BhcmVudDsNCglBTFRFUiBUQUJMRSBwYXJlbnQgQUxURVIgQ09MVU1O IHBhcmVudF9maWVsZCBTRVQgREFUQSBUWVBFIEJJR0lOVDsNCg0KVGhpcyB0aHJvd3MgdGhlIGZv bGxvd2luZyBlcnJvcjoNCglFUlJPUjogIHJlbGF0aW9uIDE2NDU4IGhhcyBtdWx0aXBsZSBjbHVz dGVyZWQgaW5kZXhlcw0KCSdTRUxFQ1QgMTY0NTg6OnJlZ2NsYXNzJyByZXR1cm5zICdwYXJlbnQn Ow0KVGhpcyBoYXMgcHJldmlvdXNseSB3b3JrZWQgb24gdmFyaW91cyB2ZXJzaW9ucyBvZiBwb3N0 Z3JlcyAxMiBhbmQgMTMgZm9yIG1lCihsYXRlc3QgdHJpZWQgMTMuNikNCg0KSSBoYXZlIHJlcHJv ZHVjZWQgdGhlIGZvbGxvd2luZyBvbiBib3RoIDE0LjIgYW5kIDE0LjAsIG15IHBvc3RncmVzIHZl cnNpb24KaXMgYXMgZm9sbG93czoNCglTRUxFQ1QgdmVyc2lvbigpOw0KCVBvc3RncmVTUUwgMTQu MiAoRGViaWFuIDE0LjItMS5wZ2RnMTEwKzEpIG9uIHg4Nl82NC1wYy1saW51eC1nbnUsIGNvbXBp bGVkCmJ5IGdjYyAoRGViaWFuIDEwLjIuMS02KSAxMC4yLjEgMjAyMTAxMTAsIDY0LWJpdA0KDQpT b21lIG1pbm9yIG9ic2VydmF0aW9uczoNCi0gUmVtb3ZpbmcgdGhlIEZLIGFsbG93cyB0aGUgZGF0 YSB0eXBlIHRvIGJlIGNoYW5nZWQNCi0gT2NjdXJzIGZvciBib3RoIHByaW1hcnkga2V5L3VuaXF1 ZSBpbmRleA0KLSBPY2N1cnMgb24gb3RoZXIgZGF0YSB0eXBlcyAoZWcuIGdvaW5nIGZyb20gVEVY VCB0byBCSUdJTlQgd2l0aCAnVVNJTkcnKQ0KDQpMb29raW5nIHRocm91Z2ggcGdfY2F0YWxvZyBJ IGNhbiBhbHNvIHNlZSB0aGF0IG9ubHkgb25lIGluZGV4IGlzIGNsdXN0ZXJlZAphcyB3b3VsZCBi ZSBleHBlY3RlZDoNCglTRUxFQ1QNCgkgIHRhYmxlX2Nscy5yZWxuYW1lc3BhY2U6OnJlZ25hbWVz cGFjZTo6dGV4dCBBUyBzY2hlbWEsDQoJICB0YWJsZV9jbHMucmVsbmFtZSBBUyB0YWJsZSwNCgkg IGluZGV4X2Nscy5yZWxuYW1lIEFTIGluZGV4LA0KCSAgaW5kaXNjbHVzdGVyZWQNCglGUk9NIHBn X2luZGV4IHBpDQoJSU5ORVIgSk9JTiBwZ19jbGFzcyBpbmRleF9jbHMgT04gKHBpLmluZGV4cmVs aWQgPSBpbmRleF9jbHMub2lkKQ0KCUlOTkVSIEpPSU4gcGdfY2xhc3MgdGFibGVfY2xzIE9OIChw aS5pbmRyZWxpZCA9IHRhYmxlX2Nscy5vaWQpDQoJV0hFUkUgKHRhYmxlX2Nscy5yZWxuYW1lc3Bh Y2U6OnJlZ25hbWVzcGFjZTo6dGV4dCwgdGFibGVfY2xzLnJlbG5hbWUpID0KKCdwdWJsaWMnLCAn cGFyZW50Jyk7DQoNCgkgc2NoZW1hIHwgdGFibGUgIHwgICBpbmRleCAgIHwgaW5kaXNjbHVzdGVy ZWQNCgktLS0tLS0tLSstLS0tLS0tLSstLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tLS0tDQoJIHB1 YmxpYyB8IHBhcmVudCB8IHBrX3BhcmVudCB8IHQNCgkoMSByb3cpDQoNCk1hbnkgVGhhbmtzLA0K SG9sbHkgUm9iZXJ0cwoK --===============2538565289280126016==--