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 1qYXHX-0020r5-0B for pgsql-bugs@arkaria.postgresql.org; Tue, 22 Aug 2023 19:43:15 +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 1qYXHW-004qcX-0J for pgsql-bugs@arkaria.postgresql.org; Tue, 22 Aug 2023 19:43:13 +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 1qYWa0-00451H-0B for pgsql-bugs@lists.postgresql.org; Tue, 22 Aug 2023 18:58:15 +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 1qYWZq-000Pwj-IX for pgsql-bugs@lists.postgresql.org; Tue, 22 Aug 2023 18:58:15 +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=qCu9m9r7YU7LbcdINW1m+mk7KQgoEbfRyCqFGv35kG8=; b=IDQAZ/ocopnr9juHW8wPf3FvKI Iuq1iSukcI2jx6AweQuamsIYn0p4/Cue6FCVFlkm5F54PEbKZ0qq5jAlm+8G3CQ4z1oueK7XsHTI/ SNjCJ1VFZOx8i66nlUvuq38xGO3Y6FvoXn1QcSjuEl0Fk+v6yal+2z2I8UszTG1grItWPVR+3Wmy4 I5DJ59M4jfhnxOL21pA0KDBDRabbKQPuaM7bF6zUAG0ZDOOJazRTbF3IGdEAKTWKwbn7XE0ozTsB1 K4xt1cvfL/fxjN0j9BNsKctD7mYutmgY/C3DNkHyZeCoFGwqPhSSwdzZp7hfDO6ZkCad/5COR5Sde 4V8wTSvA==; 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 1qYWZp-0003nB-8I for pgsql-bugs@lists.postgresql.org; Tue, 22 Aug 2023 18:58:05 +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 1qYWZm-001Acz-RZ for pgsql-bugs@lists.postgresql.org; Tue, 22 Aug 2023 18:58:03 +0000 Content-Type: multipart/mixed; boundary="===============0139391966851915807==" MIME-Version: 1.0 Subject: BUG #18067: Droping function that was used to generate column drops the column, even after `DROP EXPRESSION` To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: remi.cura@gmail.com Reply-To: remi.cura@gmail.com, pgsql-bugs@lists.postgresql.org Date: Tue, 22 Aug 2023 18:57:17 +0000 Message-ID: <18067-7a71abe62f8c64ca@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 --===============0139391966851915807== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODA2NwpMb2dnZWQgYnk6ICAgICAgICAgIFLDqW1pIEN1cmEKRW1haWwg YWRkcmVzczogICAgICByZW1pLmN1cmFAZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lvbjogMTQu NwpPcGVyYXRpbmcgc3lzdGVtOiAgIFBvc3RncmVTUUwgMTQuNyBvbiBhYXJjaDY0LXVua25vd24t bGludXgtZ251LCBjb21wCkRlc2NyaXB0aW9uOiAgICAgICAgCgpgYGBTUUwNCi8qIEJVRyBSRVBP UlQ6DQogICAgSGVsbG8gZGVhciBwb3N0Z3JlcyBjb21tdW5pdHksIEkgdGhpbmsgSSBzdHVtYmxl ZCB1cG9uIGEgYnVnIGludm9sdmluZwpnZW5lcmF0ZWQgY29sdW1ucyBkZXBlbmRlbmNpZXMgDQog ICAgICAgcGVyc2lzdGluZyBhZnRlciB0aGUgY29sdW1uIGlzIG5vdCBnZW5lcmF0ZWQgYW55bW9y ZS4NCiAgICBUaGlzIGNvbnZlbmllbnQgc2NyaXB0cyBhbGxvd3MgdG8gcmVwcm9kdWNlIGVhc2ls eQ0KICAgICAgIA0KDQogLSBjcmVhdGluZyBhIHRhYmxlIHdpdGggZ2VuZXJhdGVkIGNvbHVtbiBi YXNlZCBvbiBmdW5jdGlvbg0KIC0gbWFraW5nIHRoZSBnZW5lcmF0ZWQgY29sdW1uIG5vdCBnZW5l cmF0ZWQgYW55bW9yZQ0KIC0gZHJvcHBpZ24gZnVuY3Rpb24NCiAtLT4gdGhlIGNvbHVtbiBnZXRz IGRyb3BwZWQgZW50aXJlbHkgZnJvbSB0aGUgdGFibGUgDQogDQogRXhwZWN0ZWQgb3V0Y29tZTog DQogQVMgdGhlIGNvbHVtbiBpcyBub3QgZ2VuZXJhdGVkIGFueW1vcmUsIGl0IHNob3VsZCBoYXZl IG5vdGhpbmcgdG8gZG8gd2l0aAp3aGF0IGZ1bmN0aW9uIHdhcyB1c2VkIHRvIGdlbmVyYXRlIGl0 DQogQXQgdGhlIHZlcnkgbGVhc3QsIHdlIHNob3VsZCBnZXQgYW4gZXJyb3IgbWVzc2FnZS9kZXBl bmRlbmN5IHdhcm5pbmcNCiANCiBIZXJlIGFyZSB0aGUgZnVsbCwgc2FmZSBpbnN0cnVjdGlvbnMg dG8gcmVwcm9kdWNlLg0KICogICovDQoNCi0tIHNlbGVjdCB2ZXJzaW9uKCk7DQogICAgLS0gUG9z dGdyZVNRTCAxNC43IG9uIGFhcmNoNjQtdW5rbm93bi1saW51eC1nbnUsIGNvbXBpbGVkIGJ5IGdj YyAoR0NDKQo3LjMuMSAyMDE4MDcxMiAoUmVkIEhhdCA3LjMuMS02KSwgNjQtYml0IA0KDQpDUkVB VEUgU0NIRU1BIGRlbW9fcGdfYnVnX2dlbmNvbCA7DQoNCi0tIGNyZWF0ZSBzdHJpcHBpbmcgZnVu Y3Rpb24gDQogICAgRFJPUCBGVU5DVElPTiBJRiBFWElTVFMgZGVtb19wZ19idWdfZ2VuY29sLnRl eHRfc3RyaXBwaW5nKElOIGFfc3RyaW5nCnRleHQgLCBPVVQgYV9zdHJpcHBlZF9zdHJpbmcgdGV4 dCApOw0KICAgQ1JFQVRFIE9SIFJFUExBQ0UgRlVOQ1RJT04gZGVtb19wZ19idWdfZ2VuY29sLnRl eHRfc3RyaXBwaW5nKElOIGFfc3RyaW5nCnRleHQgLCBPVVQgYV9zdHJpcHBlZF9zdHJpbmcgdGV4 dCApIA0KICAgIFJFVFVSTlMgVEVYVA0KICAgIExBTkdVQUdFIFNRTCAgICBJTU1VVEFCTEUgICAg IFNUUklDVCAgICAgUEFSQUxMRUwgU0FGRQ0KICAgIEFTICRmdW4xJA0KICAgICAgICBTRUxFQ1Qg VFJJTShCT1RIICcvJyBGUk9NIGFfc3RyaW5nKSA7IA0KICAgICRmdW4xJDsgDQoNCi0tIGNyZWF0 ZSBoYXNoaW5nIGZ1bmN0aW9uDQogICAgRFJPUCBGVU5DVElPTiBJRiBFWElTVFMgZGVtb19wZ19i dWdfZ2VuY29sLnN0cmluZzJ1dWlkKGFfc3RyaW5nIHRleHQpOw0KICAgIENSRUFURSBPUiBSRVBM QUNFIEZVTkNUSU9OIGRlbW9fcGdfYnVnX2dlbmNvbC5zdHJpbmcydXVpZCggYV9zdHJpbmcKdGV4 dCkNCiAgICBSRVRVUk5TIHV1aWQgDQogICAgTEFOR1VBR0UgU1FMIElNTVVUQUJMRSBTVFJJQ1Qg UEFSQUxMRUwgU0FGRSBBUyAkJCAgIA0KICAgICAgICBTRUxFQ1QgdXVpZF9nZW5lcmF0ZV92NSgN CiAgICAgICAgICAgIHV1aWRfbnNfdXJsKCkNCiAgICAgICAgICAgICwgIGRlbW9fcGdfYnVnX2dl bmNvbC50ZXh0X3N0cmlwcGluZyhhX3N0cmluZykNCiAgICAgICAgKSA7DQogICAgJCQgOw0KDQot LSBjcmVhdGUgdGFibGUgd2l0aCBnZW5lcmF0ZWQgY29sdW1uIHVzaW5nIGZ1bmN0aW9uDQogICAg RFJPUCBUQUJMRSBJRiBFWElTVFMgZGVtb19wZ19idWdfZ2VuY29sLmFfdGFibGUgOw0KICAgIENS RUFURSBUQUJMRSBkZW1vX3BnX2J1Z19nZW5jb2wuYV90YWJsZSAoDQogICAgICAgIHNvbWVfc3Ry aW5nIHRleHQgDQogICAgICAgICwgc29tZV9oYXNoIHRleHQgR0VORVJBVEVEIEFMV0FZUyBBUwoo ZGVtb19wZ19idWdfZ2VuY29sLnN0cmluZzJ1dWlkKApkZW1vX3BnX2J1Z19nZW5jb2wudGV4dF9z dHJpcHBpbmcoc29tZV9zdHJpbmcpKSApIFNUT1JFRCANCiAgICApOyANCiAgICANCg0KLS0gaW5z ZXJ0aW5nIHNvbWUgc3RyaW5ncyANCiAgICBJTlNFUlQgSU5UTyBkZW1vX3BnX2J1Z19nZW5jb2wu YV90YWJsZSAoIHNvbWVfc3RyaW5nKSANCiAgICBTRUxFQ1QgY29uY2F0KCcvJywgcywgJy8nKQ0K ICAgIEZST00gZ2VuZXJhdGVfc2VyaWVzKCcxMDAwLzAxLzAxJzo6RGF0ZSwnMTAwMC8wMS8zJzo6 ZGF0ZSwgJzEgZGF5JyApIGFzCnMgOw0KICAgIA0KICAgIFNFTEVDVCAqIA0KICAgIEZST00gZGVt b19wZ19idWdfZ2VuY29sLmFfdGFibGU7DQogICAgICAgIC0tICAgIHNvbWVfc3RyaW5nICAgICAg ICAgICAgICAgICAgIHxzb21lX2hhc2ggICAgICAgICAgICAgICAgICAgICAgCiAgICB8DQogICAg ICAgIC0tICAgCi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0rDQogICAgICAgIC0tICAgIC8xMDAwLTAxLTAxCjAwOjAwOjAw LTA0OjU2OjAyL3wyNDI3NDVjOC0yMzRiLTU4MjItYmU2Ni1jYTRjYmY2Yjk5NzN8DQogICAgICAg IC0tICAgIC8xMDAwLTAxLTAyCjAwOjAwOjAwLTA0OjU2OjAyL3xmNmYzYzVkZS0wN2UzLTVmNGIt YmNjMC0zZDM3ZDdkNzhlM2N8DQogICAgICAgIC0tICAgIC8xMDAwLTAxLTAzCjAwOjAwOjAwLTA0 OjU2OjAyL3xjZTZjMzE3Yy1iMzZiLTVhZjEtOTM3MS1jYTkwODdjMzNjNDN8DQoNCi0tIG5vdyBt YWtlIHRoZSBjb2x1bW4gbm90IGdlbmVyYXRlZDoNCiAgICBBTFRFUiBUQUJMRSBkZW1vX3BnX2J1 Z19nZW5jb2wuYV90YWJsZSBBTFRFUiBDT0xVTU4gc29tZV9oYXNoIERST1AKRVhQUkVTU0lvbiA7 IA0KDQotLSB3ZSBjYW4gc3RpbGwgYWNjZXNzIHRoZSBjb2x1bW4sIGV2ZXJ5dGhpbmcgZmluZSAN CiAgICBTRUxFQ1QgKiANCiAgICBGUk9NIGRlbW9fcGdfYnVnX2dlbmNvbC5hX3RhYmxlOw0KDQoN Ci0tIGluc2VydGluZyBuZXcgdmFsdWVzIC0tPiB0aGUgY29sdW1uIGlzIG5vdCBnZW5lcmF0ZWQg YW55bW9yZSAtLT4gZXhwZWN0ZWQKYmVoYXZpb3INCiAgICBJTlNFUlQgSU5UTyBkZW1vX3BnX2J1 Z19nZW5jb2wuYV90YWJsZSAoIHNvbWVfc3RyaW5nKSANCiAgICBTRUxFQ1QgY29uY2F0KCcvJywg cywgJy8nKQ0KICAgIEZST00gZ2VuZXJhdGVfc2VyaWVzKCcyMDAwLzAxLzAxJzo6RGF0ZSwnMjAw MC8wMS8wMyc6OmRhdGUsICcxIGRheScgKSBhcwpzIDsNCiAgICANCiAgICAgICAgU0VMRUNUICog DQogICAgICAgIEZST00gZGVtb19wZ19idWdfZ2VuY29sLmFfdGFibGU7DQogICAgICAgIC0tICAg IHNvbWVfc3RyaW5nICAgICAgICAgICAgICAgICAgIHxzb21lX2hhc2ggICAgICAgICAgICAgICAg ICAgICAgCiAgICB8DQogICAgICAgIC0tICAgCi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LSstLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0rDQogICAgICAgIC0tICAgIC8x MDAwLTAxLTAxCjAwOjAwOjAwLTA0OjU2OjAyL3wyNDI3NDVjOC0yMzRiLTU4MjItYmU2Ni1jYTRj YmY2Yjk5NzN8DQogICAgICAgIC0tICAgIC8xMDAwLTAxLTAyCjAwOjAwOjAwLTA0OjU2OjAyL3xm NmYzYzVkZS0wN2UzLTVmNGItYmNjMC0zZDM3ZDdkNzhlM2N8DQogICAgICAgIC0tICAgIC8xMDAw LTAxLTAzCjAwOjAwOjAwLTA0OjU2OjAyL3xjZTZjMzE3Yy1iMzZiLTVhZjEtOTM3MS1jYTkwODdj MzNjNDN8DQogICAgICAgIC0tICAgIC8yMDAwLTAxLTAxIDAwOjAwOjAwLTA1LyAgICAgIHwgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAgICB8DQogICAgICAgIC0tICAgIC8yMDAwLTAx LTAyIDAwOjAwOjAwLTA1LyAgICAgIHwgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAg ICB8DQogICAgICAgIC0tICAgIC8yMDAwLTAxLTAzIDAwOjAwOjAwLTA1LyAgICAgIHwgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgCiAgICB8DQoNCi0tIG5vdyBkcm9wIHRoZSBmdW5jdGlv biB0aGF0IHdhcyB1c2VkIHRvIGdlbmVyYXQgdGhlIGNvbHVtbiANCiAgICBEUk9QIEZVTkNUSU9O IElGIEVYSVNUUyBkZW1vX3BnX2J1Z19nZW5jb2wudGV4dF9zdHJpcHBpbmcoSU4gYV9zdHJpbmcK dGV4dCAsIE9VVCBhX3N0cmlwcGVkX3N0cmluZyB0ZXh0ICk7DQoNCi0tPiB0aGUgY29sdW1uIGdv dCBkcm9wcGVkICEgDQogICAgU0VMRUNUIHNvbWVfc3RyaW5nLCBzb21lX2hhc2gNCiAgICBGUk9N IGRlbW9fcGdfYnVnX2dlbmNvbC5hX3RhYmxlOw0KICAgICAgICAtLT4gLyFcIEVycm9yIFs0Mjcw M106IEVSUk9SOiBjb2x1bW4gInNvbWVfaGFzaCIgZG9lcyBub3QgZXhpc3QNCg0KDQotLS0tIGNs ZWFuaW5nIA0KLS0gRFJPUCBTQ0hFTUEgSUYgRVhJU1RTIGRlbW9fcGdfYnVnX2dlbmNvbCBDQVND QURFIDsgDQpgYGAKCg== --===============0139391966851915807==--