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 1oBJOv-0005K4-3G for pgsql-admin@arkaria.postgresql.org; Tue, 12 Jul 2022 17:10:21 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oBJOt-0001l6-Te for pgsql-admin@arkaria.postgresql.org; Tue, 12 Jul 2022 17:10:19 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oBJOt-0001kv-Ja for pgsql-admin@lists.postgresql.org; Tue, 12 Jul 2022 17:10:19 +0000 Received: from jakobs.com ([85.214.83.89] helo=rs.plausibolo.de) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oBJOr-00035E-HV for pgsql-admin@lists.postgresql.org; Tue, 12 Jul 2022 17:10:19 +0000 Received: from localhost (localhost [127.0.0.1]) by rs.plausibolo.de (Postfix) with ESMTP id ED5DE380F38; Tue, 12 Jul 2022 19:10:15 +0200 (CEST) Received: from rs.plausibolo.de ([IPv6:::1]) by localhost (h2367442.stratoserver.net [IPv6:::1]) (amavisd-new, port 10024) with ESMTP id ScOBs5bZvvss; Tue, 12 Jul 2022 19:10:14 +0200 (CEST) Received: from [192.168.192.86] (dynamic-046-114-106-203.46.114.pool.telefonica.de [46.114.106.203]) by rs.plausibolo.de (Postfix) with ESMTPSA id CA18C380F2C; Tue, 12 Jul 2022 19:10:13 +0200 (CEST) Message-ID: <17ace17d-eff0-f198-7bbc-74c87957a8ae@jakobs.com> Date: Tue, 12 Jul 2022 19:10:10 +0200 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:91.0) Gecko/20100101 Thunderbird/91.10.0 Content-Language: de-DE To: pgsql-admin@lists.postgresql.org References: <60D4E7CB-BA42-4203-A5EF-9E5FA4D7CAE3@gmail.com> From: Holger Jakobs Subject: Re: Automating removal of orphaned stored procedure calls In-Reply-To: <60D4E7CB-BA42-4203-A5EF-9E5FA4D7CAE3@gmail.com> Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="------------7rgEGpvpteQFRvLoN7mS6Bdi" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --------------7rgEGpvpteQFRvLoN7mS6Bdi Content-Type: multipart/mixed; boundary="------------YDAHuQVYLmWacMj6pbOE3C8s"; protected-headers="v1" From: Holger Jakobs To: pgsql-admin@lists.postgresql.org Message-ID: <17ace17d-eff0-f198-7bbc-74c87957a8ae@jakobs.com> Subject: Re: Automating removal of orphaned stored procedure calls References: <60D4E7CB-BA42-4203-A5EF-9E5FA4D7CAE3@gmail.com> In-Reply-To: <60D4E7CB-BA42-4203-A5EF-9E5FA4D7CAE3@gmail.com> --------------YDAHuQVYLmWacMj6pbOE3C8s Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: base64 QW0gMTIuMDcuMjIgdW0gMTg6NTggc2NocmllYiBKb2huIFNjYWxpYToNCj4gT25lIG9mIG91 ciBuZXdlciBhcHBsaWNhdGlvbnMgaXMgcmVndWxhcmx5IGxlYXZpbmcgc29tZSBzdG9yZWQg cHJvY2VkdXJlcyBpbiBhIHBhcnRpYWxseSBjb21wbGV0ZWQgc3RhdGUuIEl04oCZcyBub3Qg b25lIG9mIG15IGFwcGxpY2F0aW9ucywgYW5kIHRoZSBEQkEgcmVzcG9uc2libGUgZm9yIGl0 IGhhc27igJl0IHNhaWQgd2h5IHRoaXMgaGFwcGVucywgYnV0IGhlIGlzIHRyeWluZyB0byBh dXRvbWF0ZSByZW1vdmluZyB0aGVzZS4gQ3VycmVudGx5LCBpdOKAmXMgYSBtYW51YWwgcHJv Y2VzcyB3aGVyZSB0aGV5IGxvZyBpbnRvIHRoZSBkYiBhcyB0aGUgYXBwbGljYXRpb24gb3du ZXIgd2hpY2ggb3ducyB0aGVzZSBhbmQgcmVtb3ZlIHRoZW0gbWFudWFsbHkuIEZvciB3aGF0 ZXZlciByZWFzb24gaGUgY2Fu4oCZdCB1c2UgdGhlIGFwcGxpY2F0aW9uIG93bmVy4oCZcyBJ 4oCZZCB0byBydW4gdGhpcyBwcm9jZXNzLiBJIHN1Z2dlc3RlZCBhZGRpbmcgdGhlIGFwcGxp Y2F0aW9uIG93bmVyIGFzIGEgZ3JvdXAgZm9yIHRoZSBhY3R1YWwgdXNlciBoZSBpcyBnb2lu ZyB0byB1c2UsIGFuZCBvbmNlIHRoYXQgaGFwcGVuZWQsIHVzaW5nIGEgU0VUIFJPTEUgdG8g YmVjb21lIHRoYXQgdXNlciwgYnV0IGl0IGRpZCBub3QgYXBwYXJlbnRseSB3b3JrLiBBbnli b2R5IGhhdmUgYW55IGdvb2QgaWRlYXMgaGVyZSB0byBtYWtlIHRoaXMgd29yaz8NCg0KPiBT ZW50IGZyb20gbXkgaVBhZCAoSG93IG5pY2UgeW91IGFyZSBhZHZlcnRpc2luZyB0aGUgZGV2 aWNlIHlvdSBhcmUgdXNpbmcuIElzIHRoaXMgcmVsZXZhbnQgdG8geW91ciBxdWVzdGlvbj8p DQoNCkkgY2Fubm90IHNlZSBhbnkgY29ubmVjdGlvbiBiZXR3ZWVuIGEgdHJhbnNhY3Rpb24g ImhhbmdpbmciIGFuZCB0aGUgDQp1c2FnZSBvZiBzdG9yZWQgcHJvY2VkdXJlcy4gT2YgY291 cnNlIGl0IGNhbiBoYXBwZW4gYW55d2hlcmUsIGlmIGEgDQp0cmFuc2FjdGlvbiBpcyB0cnlp bmcgdG8gdXBkYXRlIHJvd3MgYW5vdGhlciB0cmFuc2FjdGlvbiBoYXMgdXBkYXRlZCANCndp dGhvdXQgaGF2aW5nIGNvbXBsZXRlZC4NCg0KVHJ5IHRvIGZpbmQgb3V0IGJ5IGxvb2tpbmcg aW50byBwZ19sb2NrcyB3aGF0IGlzIGhhcHBlbmluZy4NCg0KLS0gDQpIb2xnZXIgSmFrb2Jz LCBCZXJnaXNjaCBHbGFkYmFjaCwgVGVsLiArNDktMTc4LTk3NTkwMTINCg0K --------------YDAHuQVYLmWacMj6pbOE3C8s-- --------------7rgEGpvpteQFRvLoN7mS6Bdi Content-Type: application/pgp-signature; name="OpenPGP_signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="OpenPGP_signature" -----BEGIN PGP SIGNATURE----- wmMEABEIACMWIQScuJCxWJK1p5BOebGKV5yTsxlhugUCYs2q8gUDAAAAAAAKCRCKV5yTsxlhupzY AJ4oAqD+VkpHY933WD+0Np3UzrIzXACg1HhuJ00sVXcX1xv6DZvN48esznY= =3+Px -----END PGP SIGNATURE----- --------------7rgEGpvpteQFRvLoN7mS6Bdi--