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 1qtAtj-00BBDP-Vj for pgsql-bugs@arkaria.postgresql.org; Wed, 18 Oct 2023 18:04:00 +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 1qtAti-00788t-20 for pgsql-bugs@arkaria.postgresql.org; Wed, 18 Oct 2023 18:03:58 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qtAaV-00702f-UN for pgsql-bugs@lists.postgresql.org; Wed, 18 Oct 2023 17:44:08 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qtAaS-001Ozm-Ip for pgsql-bugs@lists.postgresql.org; Wed, 18 Oct 2023 17:44:08 +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=M1rkOQUbjEQV0buaqEg/5+Qr7qrwNuzfY/ehCFc3yDk=; b=ZZSF3EJcMXSp43JDIrCvHrSLe7 KJThDrFAYVqV0QCie43H4nwIrSY/rZ0lqOXmHu3S+ka48if6x8QZOzvKTK2vmGEfPlVNgmWMcpGAp SEp7kJ2QxbZPC49fAbM++kM0hHGOme63MOc1TLuyZyKhJjwR5x7+wWNxx4Zu3XbEHDxH4pIQrqh1j JYIqXEtKKhvwyLCPc93EMusEKZUIkjiFAFyGJgqGWHxKpgPBFHCO80W/GNsrBy7xDoMdwBtJ5F+Mj wAvLfYudakaKzbgiBO5zbHZQ1Fp1ac6ELrVqQXPY0a9A1hpXe1beV5iVpSJfUBzwYPhVF2PMooDne dQVJI/yg==; 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 1qtAaS-0004h9-C6 for pgsql-bugs@lists.postgresql.org; Wed, 18 Oct 2023 17:44:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qtAaP-004JbZ-PB for pgsql-bugs@lists.postgresql.org; Wed, 18 Oct 2023 17:44:02 +0000 Content-Type: multipart/mixed; boundary="===============8378356394622873193==" MIME-Version: 1.0 Subject: BUG #18161: ALTER TABLE ... ALTER COLUMN does not remove dependencies in automatically from column and sequence. To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: asotolongo@gmail.com Reply-To: asotolongo@gmail.com, pgsql-bugs@lists.postgresql.org Date: Wed, 18 Oct 2023 17:43:08 +0000 Message-ID: <18161-6f5840d311f0a100@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 --===============8378356394622873193== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODE2MQpMb2dnZWQgYnk6ICAgICAgICAgIEFudGhvbnkgU290b2xvbmdv IExlw7NuCkVtYWlsIGFkZHJlc3M6ICAgICAgYXNvdG9sb25nb0BnbWFpbC5jb20KUG9zdGdyZVNR TCB2ZXJzaW9uOiAxNS40Ck9wZXJhdGluZyBzeXN0ZW06ICAgVWJ1bnR1IDIyLjA0LjMgTFRTCkRl c2NyaXB0aW9uOiAgICAgICAgCgpJIGFtIHRyeWluZyB0byBjaGFuZ2UgdGhlIGRlZmF1bHQgdmFs dWUoYSBzZXF1ZW5jZSkgZm9yIGEgY29sdW1uIHRvIGFub3RoZXIKY29sdW1uLCBidXQgdGhlIGRl cGVuZGVuY2llcyBhcmUgbm90IHJlbW92ZWQgZnJvbSB0aGUgcGdfZGVwZW5kIHRhYmxlLCB0aGVu CkkgY2Fubm90IGRlbGV0ZSB0aGUgb2xkIGNvbHVtbiwgIGZvciBleGFtcGxlOg0KDQpleGFtcGxl PSMgQ1JFQVRFIFRBQkxFIGV4YW1wbGUgKGkgc2VyaWFsICwgaiB0ZXh0KTsNCkNSRUFURSBUQUJM RQ0KZXhhbXBsZT0jIFxkKyBleGFtcGxlDQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgVGFibGUKInB1YmxpYy5leGFtcGxlIg0KIENvbHVtbiB8 ICBUeXBlICAgfCBDb2xsYXRpb24gfCBOdWxsYWJsZSB8ICAgICAgICAgICAgICBEZWZhdWx0ICAg ICAgICAgICAgIAogfCBTdG9yYWdlICB8IENvbXByZXNzaW9uIHwgU3RhdHMgdGFyZ2V0IHwgRGVz Y3JpcHRpb24gDQotLS0tLS0tLSstLS0tLS0tLS0rLS0tLS0tLS0tLS0rLS0tLS0tLS0tLSstLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0t Ky0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0NCiBpICAgICAgfCBpbnRlZ2VyIHwgICAgICAg ICAgIHwgbm90IG51bGwgfApuZXh0dmFsKCdleGFtcGxlX2lfc2VxJzo6cmVnY2xhc3MpIHwgcGxh aW4gICAgfCAgICAgICAgICAgICB8ICAgICAgICAgICAgICB8Cg0KIGogICAgICB8IHRleHQgICAg fCAgICAgICAgICAgfCAgICAgICAgICB8ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg IAogfCBleHRlbmRlZCB8ICAgICAgICAgICAgIHwgICAgICAgICAgICAgIHwgDQpBY2Nlc3MgbWV0 aG9kOiBoZWFwDQoNCmV4YW1wbGU9IyBhbHRlciB0YWJsZSBleGFtcGxlIGFkZCBjb2x1bW4gaV9u ZXcgYmlnaW50Ow0KQUxURVIgVEFCTEUNCmV4YW1wbGU9IyBhbHRlciB0YWJsZSBleGFtcGxlIGFs dGVyIGNvbHVtbiBpIGRyb3AgZGVmYXVsdCA7DQpBTFRFUiBUQUJMRQ0KZXhhbXBsZT0jIGFsdGVy IHRhYmxlIGV4YW1wbGUgYWx0ZXIgY29sdW1uIGlfbmV3IHNldCBkZWZhdWx0Cm5leHR2YWwoJ2V4 YW1wbGVfaV9zZXEnOjpyZWdjbGFzcyk7DQpBTFRFUiBUQUJMRQ0KZXhhbXBsZT0jIFxkKyBleGFt cGxlDQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgVGFibGUKInB1YmxpYy5leGFtcGxlIg0KIENvbHVtbiB8ICBUeXBlICAgfCBDb2xsYXRpb24g fCBOdWxsYWJsZSB8ICAgICAgICAgICAgICBEZWZhdWx0ICAgICAgICAgICAgIAogfCBTdG9yYWdl ICB8IENvbXByZXNzaW9uIHwgU3RhdHMgdGFyZ2V0IHwgRGVzY3JpcHRpb24gDQotLS0tLS0tLSst LS0tLS0tLS0rLS0tLS0tLS0tLS0rLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0rLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tKy0tLS0t LS0tLS0tLS0NCiBpICAgICAgfCBpbnRlZ2VyIHwgICAgICAgICAgIHwgbm90IG51bGwgfCAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKIHwgcGxhaW4gICAgfCAgICAgICAgICAgICB8 ICAgICAgICAgICAgICB8IA0KIGogICAgICB8IHRleHQgICAgfCAgICAgICAgICAgfCAgICAgICAg ICB8ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogfCBleHRlbmRlZCB8ICAgICAg ICAgICAgIHwgICAgICAgICAgICAgIHwgDQogaV9uZXcgIHwgYmlnaW50ICB8ICAgICAgICAgICB8 ICAgICAgICAgIHwKbmV4dHZhbCgnZXhhbXBsZV9pX3NlcSc6OnJlZ2NsYXNzKSB8IHBsYWluICAg IHwgICAgICAgICAgICAgfCAgICAgICAgICAgICAgfAoNCkFjY2VzcyBtZXRob2Q6IGhlYXANCg0K ZXhhbXBsZT0jIGFsdGVyIHRhYmxlIGV4YW1wbGUgZHJvcCBjb2x1bW4gaTsNCkVSUk9SOiAgY2Fu bm90IGRyb3AgY29sdW1uIGkgb2YgdGFibGUgZXhhbXBsZSBiZWNhdXNlIG90aGVyIG9iamVjdHMg ZGVwZW5kCm9uIGl0DQpERVRBSUw6ICBkZWZhdWx0IHZhbHVlIGZvciBjb2x1bW4gaV9uZXcgb2Yg dGFibGUgZXhhbXBsZSBkZXBlbmRzIG9uIHNlcXVlbmNlCmV4YW1wbGVfaV9zZXENCkhJTlQ6ICBV c2UgRFJPUCAuLi4gQ0FTQ0FERSB0byBkcm9wIHRoZSBkZXBlbmRlbnQgb2JqZWN0cyB0b28uDQpl eGFtcGxlPSMgU0VMRUNUIHQub2lkOjpyZWdjbGFzcyBBUyB0YWJsZV9uYW1lLA0KICAgICAgIGEu YXR0bmFtZSBBUyBjb2x1bW5fbmFtZSwNCiAgICAgICBzLnJlbG5hbWUgQVMgc2VxdWVuY2VfbmFt ZSwgZC4qDQpGUk9NIHBnX2NsYXNzIEFTIHQNCiAgIEpPSU4gcGdfYXR0cmlidXRlIEFTIGENCiAg ICAgIE9OIGEuYXR0cmVsaWQgPSB0Lm9pZA0KICAgSk9JTiBwZ19kZXBlbmQgQVMgZA0KICAgICAg T04gZC5yZWZvYmppZCA9IHQub2lkDQogICAgICAgICBBTkQgZC5yZWZvYmpzdWJpZCA9IGEuYXR0 bnVtDQogICBKT0lOIHBnX2NsYXNzIEFTIHMNCiAgICAgIE9OIHMub2lkID0gZC5vYmppZA0KV0hF UkUgZC5jbGFzc2lkID0gJ3BnX2NhdGFsb2cucGdfY2xhc3MnOjpyZWdjbGFzcw0KICBBTkQgZC5y ZWZjbGFzc2lkID0gJ3BnX2NhdGFsb2cucGdfY2xhc3MnOjpyZWdjbGFzcw0KICBBTkQgZC5kZXB0 eXBlIElOICgnaScsICdhJykNCiAgQU5EIHQucmVsa2luZCBJTiAoJ3InLCAnUCcpDQogIEFORCBz LnJlbGtpbmQgPSAnUycgOw0KDQogdGFibGVfbmFtZSB8IGNvbHVtbl9uYW1lIHwgc2VxdWVuY2Vf bmFtZSB8IGNsYXNzaWQgfCAgb2JqaWQgIHwgb2Jqc3ViaWQgfApyZWZjbGFzc2lkIHwgcmVmb2Jq aWQgfCByZWZvYmpzdWJpZCB8IGRlcHR5cGUgDQotLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLSst LS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tKy0tLS0tLS0tLSstLS0tLS0tLS0tKy0tLS0tLS0tLS0t LSstLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tDQogZXhhbXBsZSAgICB8IGkgICAg ICAgICAgIHwgZXhhbXBsZV9pX3NlcSB8ICAgIDEyNTkgfCAzMjE3MzQ3IHwgICAgICAgIDAgfCAg CiAgICAxMjU5IHwgIDMyMTczNDggfCAgICAgICAgICAgMSB8IGENCigxIHJvdykNCg0KDQotLWlm IGkgZGVsZXRlIHRoZSBkZXBlbmRlbmN5IG1hbnVhbGx5LCB0aGVuIEkgY2FuIGRyb3AgdGhlIGNv bHVtbjoNCg0KZXhhbXBsZT0jIGRlbGV0ZSBmcm9tIHBnX2RlcGVuZCB3aGVyZSBvYmppZD0zMjE3 MzQ3IGFuZCByZWZjbGFzc2lkPTEyNTkgYW5kCnJlZm9iamlkPTMyMTczNDg7DQpERUxFVEUgMQ0K ZXhhbXBsZT0jIGFsdGVyIHRhYmxlIGV4YW1wbGUgZHJvcCBjb2x1bW4gaTsNCkFMVEVSIFRBQkxF DQoNCg0KDQpJbiBhZGRpdGlvbiwgbmVpdGhlciBJIGNhbiBub3Qgc2VlIHRoZSByZWxhdGlvbnNo aXAgYmV0d2VlbiB0aGUgaV9uZXcgY29sdW1uCmFuZCB0aGUgc2VxdWVuY2UNCg0KYWxsIG9mIHRo ZXNlLCBJdCBpcyBub3JtYWwgYmVoYXZpb3Igb3IgaXMgaXQgYSBidWc/Cgo= --===============8378356394622873193==--