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 1uJvw0-009e4G-EK for pgsql-admin@arkaria.postgresql.org; Tue, 27 May 2025 15:09:44 +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 1uJvvz-008uG8-6u for pgsql-admin@arkaria.postgresql.org; Tue, 27 May 2025 15:09:43 +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 1uJvvy-008uFx-Qq for pgsql-admin@lists.postgresql.org; Tue, 27 May 2025 15:09:42 +0000 Received: from mail-ed1-x52b.google.com ([2a00:1450:4864:20::52b]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uJvvw-000O8M-0L for pgsql-admin@lists.postgresql.org; Tue, 27 May 2025 15:09:42 +0000 Received: by mail-ed1-x52b.google.com with SMTP id 4fb4d7f45d1cf-6021b8b2c5fso6720687a12.2 for ; Tue, 27 May 2025 08:09:40 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1748358579; x=1748963379; darn=lists.postgresql.org; h=mime-version:content-language:accept-language:in-reply-to :references:message-id:date:thread-index:thread-topic:subject:cc:to :from:from:to:cc:subject:date:message-id:reply-to; bh=1rJR1ukc787UTUuI6hiuSk3S20ptQles3dSoLDdjztw=; b=MRubWGa7yTMUVkWkSpLZ76Vbxu1ZzbqjBbiTHzFHR6ECZlVT2KVrYqmfQ0AXDuHlLe fCTmbrdLJNMcYuCgnoKMKXNyivzkMw2UM8LmlIcZolQ/ExYzyUOptyWb6nJj0YUD9tuU sX7OewlglAaefS+VPJkldFZZZg5R/VJRAYPISnsYY2siFefgMKCMKMkibdiDlNplTkzU j2kbjt9Fzn75f/qp/MQy8KAu6Nc/PIoy6UuJqt6w//XHjUxhElJnvo0+ikf0wh637wuC FlJzJkZ73/CwROT9a6i6yB7qeLlNKUeuzxp9ZURFX22SHJxtdd55fkxNGOlRsNs6zQby AMxQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1748358579; x=1748963379; h=mime-version:content-language:accept-language:in-reply-to :references:message-id:date:thread-index:thread-topic:subject:cc:to :from:x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=1rJR1ukc787UTUuI6hiuSk3S20ptQles3dSoLDdjztw=; b=DwPUFIqk3yNJubT8iZ4dAQWZ1JOBwc3fJtiTR7Y+cq1b9Cyc+PPpaskQ402WVQo9+l 0N5JX3YqlBw6N3+pkmJpCYQC6nKJ+FCkEWejB50+L0ldAxSXHVWb4hcjw0Q8DD3W5nw8 X6l21hl0mZu1zKXA5igBanbX4PcTjspukJ3r0CeXLuNCN95OboJHDFkT/a6615DGpzzA acMXHDSenXyUh9emxnIS9lwPA96yXsDwpQTLJv0bSCOqIrf5nZ8nIK6SKTaKgCpro8F8 vMUViQq5ocPIed5fLpt17F9eFX1Y9rSjSn+Y/ia+MDBs0yHRgJrLXJ1CF37RGa3dzfAa 3d8g== X-Gm-Message-State: AOJu0YwKV5YcQVV5JdekJFnq6XTAlptHCLiBbrwdh3BoSPCY8GdNkgfR 4j86jb3z4f6LpiUpFjdQYiQVRa0ZUaPrqlvrEac9TCziN1faWPGyXLemHU6me3fE X-Gm-Gg: ASbGncvxd8wKX4q5W2PiRiHAri8Wc/h692vLh7LwfEWLmujPEAWsvh5HxESnl0uhfks UdHWgREYbZaliIewBjc201JfRCV95jbliH0DIM6kg6IhPpcIrDyLpy5pWcGKm3jTYiIpyTlpIFi 4HEi5AM2JeascgDvuM7cSHlXT0RaUt5O5LeBZpq/qt3ZgnZFhXVWaXQy2bcICCLRceY83hC2umI HPgPj+VanMDjhf54k2rBsl3L7NMF02apdOL+0P09lJfg7Znq/XeRN+KCIPhH2wAiLXgxAp2emj7 DH5H3a3bizczp0BT45Oiz7n/IFaOUMutqJLmCtq+RHohEvsH7SnKyX1pJSigCkmKlIrVwql5pH+ 5Rqqbm1h+gj4iQYVlaK1HWLxC3uElsJ0vDNrUyv6h1lY= X-Google-Smtp-Source: AGHT+IFs8l8yaTt3hP/a9pPdexRGhs8fcVnkktE1N7ELPvbbf8JQ5NlB6H9cq17cZcFHOrXyWa3Zfw== X-Received: by 2002:a17:906:4698:b0:ad8:9b5d:2c2f with SMTP id a640c23a62f3a-ad89b5d2ee4mr13733166b.4.1748358579210; Tue, 27 May 2025 08:09:39 -0700 (PDT) Received: from AS4PR03MB8506.eurprd03.prod.outlook.com ([2603:1026:c03:7052::5]) by smtp.gmail.com with ESMTPSA id a640c23a62f3a-ad8908a54d5sm107834466b.61.2025.05.27.08.09.38 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 27 May 2025 08:09:38 -0700 (PDT) From: David Okeamah To: "David G. Johnston" , Edwin UY CC: Pgsql-admin Subject: Re: How to check if a Procedure or FUNCTION EXIST Thread-Topic: How to check if a Procedure or FUNCTION EXIST Thread-Index: AVFYTkhwSKoHth314hiNw2UcJgX+3UF4Xzg5kuHTAh0= X-MS-Exchange-MessageSentRepresentingType: 1 Date: Tue, 27 May 2025 15:09:16 +0000 Message-ID: References: In-Reply-To: Accept-Language: en-US Content-Language: en-GB X-MS-Has-Attach: X-MS-Exchange-Organization-SCL: -1 X-MS-TNEF-Correlator: X-MS-Exchange-Organization-RecordReviewCfmType: 0 x-ms-reactions: allow Content-Type: multipart/alternative; boundary="_000_AS4PR03MB8506D1C129C7615EE4695EE9F764AAS4PR03MB8506eurp_" MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_AS4PR03MB8506D1C129C7615EE4695EE9F764AAS4PR03MB8506eurp_ Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 R28gYWhlYWQNCg0KREFWSUQgT0tFQU1BSCxERVZFTE9QRVINCl9fX19fX19fX19fX19fX19fX19f X19fX19fX19fX19fDQpGcm9tOiBEYXZpZCBHLiBKb2huc3RvbiA8ZGF2aWQuZy5qb2huc3RvbkBn bWFpbC5jb20+DQpTZW50OiBUdWVzZGF5LCBNYXkgMjcsIDIwMjUgNDowNjo0NCBQTQ0KVG86IEVk d2luIFVZIDxlZHdpbi51eUBnbWFpbC5jb20+DQpDYzogUGdzcWwtYWRtaW4gPHBnc3FsLWFkbWlu QGxpc3RzLnBvc3RncmVzcWwub3JnPg0KU3ViamVjdDogUmU6IEhvdyB0byBjaGVjayBpZiBhIFBy b2NlZHVyZSBvciBGVU5DVElPTiBFWElTVA0KDQpPbiBUdWUsIE1heSAyNywgMjAyNSBhdCA4OjAy 4oCvQU0gRWR3aW4gVVkgPGVkd2luLnV5QGdtYWlsLmNvbTxtYWlsdG86ZWR3aW4udXlAZ21haWwu Y29tPj4gd3JvdGU6DQpJIHdhbnQgdG8gY2hlY2sgZm9yIGZ1bmN0aW9uIGFuZCBwcm9jZWR1cmUg aWYgdGhleSBleGlzdCBvciBub3QgaW5jbHVkaW5nIHRob3NlIGNyZWF0ZWQgYnkgdGhlIHVzZXJz IGFzIHdlbGwgYXMgc3lzdGVtIGZ1bmN0aW9ucw0KDQpBcmUgeW91IGF3YXJlIHRoYXQgZXZlbiBp biB0aGUgc2FtZSBzY2hlbWEgbXVsdGlwbGUgZnVuY3Rpb25zIGFuZCBwcm9jZWR1cmVzIGNhbiBz aGFyZSB0aGUgc2FtZSAibmFtZSI/DQoNCg0KcHJvb3duZXIgd2hldGhlciBpdCBpcyBhIHN5c3Rl bSBmdW5jdGlvbiBvciB1c2VyLWRlZmluZWQ/DQoNCg0KVGhhdCBzZWVtcyBsaWtlIGEgcG9vciB0 ZXN0IGZvciB0aGF0IHByb3BlcnR5LiAgQSBzeXN0ZW0gZnVuY3Rpb24gaXMgb25lIHRoYXQgZXhp c3RzIGluIHRoZSBwZ19jYXRhbG9nIHNjaGVtYSwgd2hpY2ggaXMgdGhlIHNjaGVtYSB0aGUgc3lz dGVtIHBsYWNlcyBhbGwgb2YgaXRzIG9iamVjdHMgaW50by4NCg0KRGF2aWQgSi4NCg0K --_000_AS4PR03MB8506D1C129C7615EE4695EE9F764AAS4PR03MB8506eurp_ Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: base64 PGh0bWw+DQo8aGVhZD4NCjxtZXRhIGh0dHAtZXF1aXY9IkNvbnRlbnQtVHlwZSIgY29udGVudD0i dGV4dC9odG1sOyBjaGFyc2V0PXV0Zi04Ij4NCjwvaGVhZD4NCjxib2R5Pg0KPGRpdj4NCjxkaXYg ZGlyPSJsdHIiPkdvIGFoZWFkPC9kaXY+DQo8L2Rpdj4NCjxkaXYgaWQ9Im1zLW91dGxvb2stbW9i aWxlLWJvZHktc2VwYXJhdG9yLWxpbmUiIGRpcj0iYXV0byI+PGJyPg0KPC9kaXY+DQo8ZGl2IGlk PSJtcy1vdXRsb29rLW1vYmlsZS1zaWduYXR1cmUiPg0KPGRpdiBkaXI9Imx0ciI+REFWSUQgT0tF QU1BSCxERVZFTE9QRVImbmJzcDs8L2Rpdj4NCjwvZGl2Pg0KPGhyIHN0eWxlPSJkaXNwbGF5Omlu bGluZS1ibG9jazt3aWR0aDo5OCUiIHRhYmluZGV4PSItMSI+DQo8ZGl2IGlkPSJkaXZScGx5Rndk TXNnIiBkaXI9Imx0ciI+PGZvbnQgZmFjZT0iQ2FsaWJyaSwgc2Fucy1zZXJpZiIgc3R5bGU9ImZv bnQtc2l6ZToxMXB0IiBjb2xvcj0iIzAwMDAwMCI+PGI+RnJvbTo8L2I+IERhdmlkIEcuIEpvaG5z dG9uICZsdDtkYXZpZC5nLmpvaG5zdG9uQGdtYWlsLmNvbSZndDs8YnI+DQo8Yj5TZW50OjwvYj4g VHVlc2RheSwgTWF5IDI3LCAyMDI1IDQ6MDY6NDQgUE08YnI+DQo8Yj5Ubzo8L2I+IEVkd2luIFVZ ICZsdDtlZHdpbi51eUBnbWFpbC5jb20mZ3Q7PGJyPg0KPGI+Q2M6PC9iPiBQZ3NxbC1hZG1pbiAm bHQ7cGdzcWwtYWRtaW5AbGlzdHMucG9zdGdyZXNxbC5vcmcmZ3Q7PGJyPg0KPGI+U3ViamVjdDo8 L2I+IFJlOiBIb3cgdG8gY2hlY2sgaWYgYSBQcm9jZWR1cmUgb3IgRlVOQ1RJT04gRVhJU1Q8L2Zv bnQ+DQo8ZGl2PiZuYnNwOzwvZGl2Pg0KPC9kaXY+DQo8ZGl2Pg0KPGRpdiBkaXI9Imx0ciI+DQo8 ZGl2IGRpcj0ibHRyIj4NCjxkaXYgY2xhc3M9InhfZ21haWxfZGVmYXVsdCIgc3R5bGU9ImZvbnQt ZmFtaWx5OmFyaWFsLGhlbHZldGljYSxzYW5zLXNlcmlmIj48c3BhbiBzdHlsZT0iZm9udC1mYW1p bHk6QXJpYWwsSGVsdmV0aWNhLHNhbnMtc2VyaWYiPk9uIFR1ZSwgTWF5IDI3LCAyMDI1IGF0IDg6 MDLigK9BTSBFZHdpbiBVWSAmbHQ7PGEgaHJlZj0ibWFpbHRvOmVkd2luLnV5QGdtYWlsLmNvbSI+ ZWR3aW4udXlAZ21haWwuY29tPC9hPiZndDsgd3JvdGU6PC9zcGFuPjwvZGl2Pg0KPC9kaXY+DQo8 ZGl2IGNsYXNzPSJ4X2dtYWlsX3F1b3RlIHhfZ21haWxfcXVvdGVfY29udGFpbmVyIj4NCjxibG9j a3F1b3RlIGNsYXNzPSJ4X2dtYWlsX3F1b3RlIiBzdHlsZT0ibWFyZ2luOjBweCAwcHggMHB4IDAu OGV4OyBib3JkZXItbGVmdDoxcHggc29saWQgcmdiKDIwNCwyMDQsMjA0KTsgcGFkZGluZy1sZWZ0 OjFleCI+DQo8ZGl2IGRpcj0ibHRyIj4NCjxkaXY+PHNwYW4gc3R5bGU9ImZvbnQtZmFtaWx5Om1v bm9zcGFjZSI+PHNwYW4gY2xhc3M9InhfZ21haWxfZGVmYXVsdCIgc3R5bGU9ImZvbnQtZmFtaWx5 OmFyaWFsLGhlbHZldGljYSxzYW5zLXNlcmlmIj48L3NwYW4+SSB3YW50IHRvIGNoZWNrIGZvciBm dW5jdGlvbiBhbmQgcHJvY2VkdXJlIGlmIHRoZXkgZXhpc3Qgb3Igbm90IGluY2x1ZGluZyB0aG9z ZSBjcmVhdGVkIGJ5IHRoZSB1c2VycyBhcyB3ZWxsIGFzIHN5c3RlbSBmdW5jdGlvbnM8L3NwYW4+ PC9kaXY+DQo8L2Rpdj4NCjwvYmxvY2txdW90ZT4NCjxkaXY+PGJyPg0KPC9kaXY+DQo8ZGl2Pg0K PGRpdiBjbGFzcz0ieF9nbWFpbF9kZWZhdWx0IiBzdHlsZT0iZm9udC1mYW1pbHk6YXJpYWwsaGVs dmV0aWNhLHNhbnMtc2VyaWYiPkFyZSB5b3UgYXdhcmUgdGhhdCBldmVuIGluIHRoZSBzYW1lIHNj aGVtYSBtdWx0aXBsZSBmdW5jdGlvbnMgYW5kIHByb2NlZHVyZXMgY2FuIHNoYXJlIHRoZSBzYW1l ICZxdW90O25hbWUmcXVvdDs/PC9kaXY+DQo8YnI+DQo8L2Rpdj4NCjxkaXY+Jm5ic3A7PC9kaXY+ DQo8YmxvY2txdW90ZSBjbGFzcz0ieF9nbWFpbF9xdW90ZSIgc3R5bGU9Im1hcmdpbjowcHggMHB4 IDBweCAwLjhleDsgYm9yZGVyLWxlZnQ6MXB4IHNvbGlkIHJnYigyMDQsMjA0LDIwNCk7IHBhZGRp bmctbGVmdDoxZXgiPg0KPGRpdiBkaXI9Imx0ciI+DQo8ZGl2PjxzcGFuIHN0eWxlPSJmb250LWZh bWlseTptb25vc3BhY2UiPnByb293bmVyIHdoZXRoZXIgaXQgaXMgYSBzeXN0ZW0gZnVuY3Rpb24g b3IgdXNlci1kZWZpbmVkPzwvc3Bhbj48L2Rpdj4NCjxkaXY+PGJyPg0KPC9kaXY+DQo8L2Rpdj4N CjwvYmxvY2txdW90ZT4NCjxkaXY+PGJyPg0KPC9kaXY+DQo8ZGl2IGNsYXNzPSJ4X2dtYWlsX2Rl ZmF1bHQiIHN0eWxlPSJmb250LWZhbWlseTphcmlhbCxoZWx2ZXRpY2Esc2Fucy1zZXJpZiI+VGhh dCBzZWVtcyBsaWtlIGEgcG9vciB0ZXN0IGZvciB0aGF0IHByb3BlcnR5LiZuYnNwOyBBIHN5c3Rl bSBmdW5jdGlvbiBpcyBvbmUgdGhhdCBleGlzdHMgaW4gdGhlIHBnX2NhdGFsb2cgc2NoZW1hLCB3 aGljaCBpcyB0aGUgc2NoZW1hIHRoZSBzeXN0ZW0gcGxhY2VzIGFsbCBvZiBpdHMgb2JqZWN0cyBp bnRvLjwvZGl2Pg0KPGRpdiBjbGFzcz0ieF9nbWFpbF9kZWZhdWx0IiBzdHlsZT0iZm9udC1mYW1p bHk6YXJpYWwsaGVsdmV0aWNhLHNhbnMtc2VyaWYiPjxicj4NCjwvZGl2Pg0KPGRpdiBjbGFzcz0i eF9nbWFpbF9kZWZhdWx0IiBzdHlsZT0iZm9udC1mYW1pbHk6YXJpYWwsaGVsdmV0aWNhLHNhbnMt c2VyaWYiPkRhdmlkIEouPC9kaXY+DQo8ZGl2IGNsYXNzPSJ4X2dtYWlsX2RlZmF1bHQiIHN0eWxl PSJmb250LWZhbWlseTphcmlhbCxoZWx2ZXRpY2Esc2Fucy1zZXJpZiI+PGJyPg0KPC9kaXY+DQo8 L2Rpdj4NCjwvZGl2Pg0KPC9kaXY+DQo8L2JvZHk+DQo8L2h0bWw+DQo= --_000_AS4PR03MB8506D1C129C7615EE4695EE9F764AAS4PR03MB8506eurp_--