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 1uSbCU-00A5Ug-1K for pgsql-bugs@arkaria.postgresql.org; Fri, 20 Jun 2025 12:50:34 +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 1uSbCS-001PxV-5J for pgsql-bugs@arkaria.postgresql.org; Fri, 20 Jun 2025 12:50:32 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uSanr-001ECO-I9 for pgsql-bugs@lists.postgresql.org; Fri, 20 Jun 2025 12:25:08 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1uSanp-0033ZY-2I for pgsql-bugs@lists.postgresql.org; Fri, 20 Jun 2025 12:25: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=BxYtFEWCTLoKRZ6hYg9OE4xrpmm8lE/AsSM3r8fV9Q4=; b=ZzdLJgSsgCinPv57N36n9zZqxQ fO659d+Aw9YUlz4xXesy83Pcy12rrcFf+MjPqy4ogUuGQmIKkrP/NdMyazz0KPE5C0PQ1RG8HS7OL VKV1nPc1kAx29rvHeprwQ53VO3mYPWoAK3sZsze1p6LxBjLYK0WGljzl8D4Y3vSV8pMZSbF+gxb7d amwRELlay5rKfGGu2Rk29JN4eLOa+4GYuu0G2kaPgRIBabP77ZtogNBkMK0ZJh30MrpsgzBI/KFH6 T+ZhIpXurD2Swz9mg4sj0pozpWyV2DbuAdNpCBsEpA7d9u7cWWaXZqIaDGINmJH0F8oXknJs6zNwi JYhR4o8Q==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uSanp-008hFC-80 for pgsql-bugs@lists.postgresql.org; Fri, 20 Jun 2025 12:25:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1uSanm-001IHP-2w for pgsql-bugs@lists.postgresql.org; Fri, 20 Jun 2025 12:25:03 +0000 Content-Type: multipart/mixed; boundary="===============0408654762887823430==" MIME-Version: 1.0 Subject: BUG #18964: `ALTER DATABASE ... RESET ...` fails to reset extension parameters that no longer exist To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: mert@futo.org Reply-To: mert@futo.org, pgsql-bugs@lists.postgresql.org Date: Fri, 20 Jun 2025 12:24:20 +0000 Message-ID: <18964-ba09dea8c98fccd6@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 --===============0408654762887823430== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODk2NApMb2dnZWQgYnk6ICAgICAgICAgIE1lcnQgQWxldgpFbWFpbCBh ZGRyZXNzOiAgICAgIG1lcnRAZnV0by5vcmcKUG9zdGdyZVNRTCB2ZXJzaW9uOiAxNy41Ck9wZXJh dGluZyBzeXN0ZW06ICAgRGViaWFuIDEyCkRlc2NyaXB0aW9uOiAgICAgICAgCgpNeSBwcm9qZWN0 IHVzZXMgUG9zdGdyZVNRTCAoZGVmYXVsdCAxNCwgYnV0IGxhdGVyIHZlcnNpb25zIGFyZSBzdXBw b3J0ZWQgYXMKd2VsbCkgd2l0aCBhbiBleHRlbnNpb24gd2hlcmUgb25lIG9mIGl0cyBwYXJhbWV0 ZXJzIHdhcyByZW1vdmVkIGluIGEgbGF0ZXIKdmVyc2lvbi4gSSBoYWQgYXBwbGllZCBhIG5vbi1k ZWZhdWx0IHZhbHVlIGZvciB0aGlzIHBhcmFtZXRlciB1c2luZyBgQUxURVIKREFUQUJBU0UgaW1t aWNoIFNFVCB2Y2hvcmRycS5wcmV3YXJtX2RpbSA9ICc1MTIsNjQwLDc2OCwxMDI0LDExNTIsMTUz Nic7YC4KQWZ0ZXIgdXBncmFkaW5nIHRoZSBleHRlbnNpb24gdG8gYSB2ZXJzaW9uIHRoYXQgbm8g bG9uZ2VyIGluY2x1ZGVzIHRoaXMKcGFyYW1ldGVyLCBhZG1pbnMgcmVwb3J0ZWQgdGhhdCBlYWNo IGNvbm5lY3Rpb24gZW1pdHRlZCB0aGUgZm9sbG93aW5nCndhcm5pbmc6CmBgYAoyMDI1LTA2LTE4 IDIzOjMyOjQ2Ljc2NSBDRVNUIFs0OV0gV0FSTklORzogIGludmFsaWQgY29uZmlndXJhdGlvbiBw YXJhbWV0ZXIKbmFtZSAidmNob3JkcnEucHJld2FybV9kaW0iCjIwMjUtMDYtMTggMjM6MzI6NDYu NzY1IENFU1QgWzQ5XSBERVRBSUw6ICAidmNob3JkcnEiIGlzIGEgcmVzZXJ2ZWQgcHJlZml4Lgpg YGAKQXMgYSBzb2x1dGlvbiwgSSBhZGRlZCBhIG1pZ3JhdGlvbiB0aGF0IHJlbW92ZXMgdGhlIG5v dy1yZWR1bmRhbnQgcGFyYW1ldGVyCndpdGggYEFMVEVSIERBVEFCQVNFIGltbWljaCBSRVNFVCB2 Y2hvcmRycS5wcmV3YXJtX2RpbTtgLiBIb3dldmVyLCB3aGlsZQp0aGlzIHdvcmtlZCBmb3Igb3Vy IENJIHRoYXQgdXNlcyBQb3N0Z3JlcyAxNCBhbmQgZm9yIGFkbWlucyB1c2luZyAxNCwgd2UKYmVn YW4gZ2V0dGluZyByZXBvcnRzIGZyb20gYWRtaW5zIHVzaW5nIDE1LCAxNiBhbmQgMTcgdGhhdCB0 aGUgbWlncmF0aW9uCmZhaWxzIHdpdGggdGhlIGZvbGxvd2luZyBlcnJvcjoKYGBgClBvc3RncmVz RXJyb3I6IGludmFsaWQgY29uZmlndXJhdGlvbiBwYXJhbWV0ZXIgbmFtZSAidmNob3JkcnEucHJl d2FybV9kaW0iCnsKICBzZXZlcml0eV9sb2NhbDogJ0VSUk9SJywKICBzZXZlcml0eTogJ0VSUk9S JywKICBjb2RlOiAnNDI2MDInLAogIGRldGFpbDogJyJ2Y2hvcmRycSIgaXMgYSByZXNlcnZlZCBw cmVmaXguJywKICBmaWxlOiAnZ3VjLmMnLAogIGxpbmU6ICcxMTUzJywKICByb3V0aW5lOiAnYXNz aWduYWJsZV9jdXN0b21fdmFyaWFibGVfbmFtZScKfQpgYGAKV2hpbGUgbm90IGEgUEcgZGV2ZWxv cGVyLCBJIHRoaW5rIHRoaXMgaXMgbGlrZWx5IGR1ZSB0byB0aGUgY2hhbmdlIGluIGNvbW1pdApb ODgxMDM1NjdjXShodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9naXR3ZWIvP3A9cG9zdGdyZXNx bC5naXQ7YT1jb21taXRkaWZmO2g9ODgxMDM1NjdjKQp0aGF0IHdhcyBwYXJ0IG9mIHRoZSAxNSBy ZWxlYXNlLiBJdCBtYWtlcyBmb3IgYSB0cmlja3kgc2l0dWF0aW9uIHdoZXJlIGl0CnNlZW1zIHRo ZSBvcHRpb25zIHRvIHJlbW92ZSB0aGlzIHBhcmFtZXRlciBhcmU6CjEuIFdyaXRlIGRpcmVjdGx5 IHRvIGBwZ19jYXRhbG9nLnBnX2RiX3JvbGVfc2V0dGluZ2AsIHJlbW92aW5nIHRoaXMKcGFyYW1l dGVyIGZyb20gdGhlIGBzZXRjb25maWdgIGFycmF5CjIuIFJ1biBgQUxURVIgREFUQUJBU0UgaW1t aWNoIFJFU0VUIEFMTDtgLCBwdXJnaW5nIGFsbCBkYXRhYmFzZS1sZXZlbApwYXJhbWV0ZXIgY29u ZmlndXJhdGlvbiBhbG9uZyB3aXRoIGl0CjMuIE1ha2UgYSBiYWNrdXAsIHRoZW4gcmVtb3ZlIHRo ZSByZWxldmFudCBsaW5lIHRoYXQgYXBwbGllcyB0aGlzIHBhcmFtZXRlcgppbiB0aGUgYmFja3Vw IGZpbGUgYmVmb3JlIHJlc3RvcmluZwpUaGVyZSBtYXkgYmUgb3RoZXIgYXBwcm9hY2hlcyBhcyB3 ZWxsLCBidXQgYWxsIG9mIHRoZW0gYXJlIHJhdGhlciBjdW1iZXJzb21lCmFuZCBlcnJvci1wcm9u ZS4gTXkgc29sdXRpb24gd2FzIHRvIHdyaXRlIGEgdHJhbnNhY3Rpb24gdGhhdCBmaXJzdCBxdWVy aWVzCnRoZSBgc2V0Y29uZmlnYCBwYXJhbWV0ZXJzLCB0aGVuIHJ1bnMgYFJFU0VUIEFMTGAsIHRo ZW4gcmUtYXBwbGllcyBhbGwKcGFyYW1ldGVycyBleGNlcHQgYHZjaG9yZHJxLnByZXdhcm1fZGlt YCB1c2luZyB0aGUgcXVlcmllZCBkYXRhLgpJdCB3b3VsZCBiZSBncmVhdCBpZiBgUkVTRVRgaW5n IHRoZSBwYXJhbWV0ZXIgc3RpbGwgd29ya2VkIGluIHRoaXMKc2l0dWF0aW9uLCBldmVuIGlmIGBT RVRgaW5nIGl0IGRvZXMgbm90LgoK --===============0408654762887823430==--