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 1r8L7l-009Oz2-NT for pgsql-docs@arkaria.postgresql.org; Wed, 29 Nov 2023 14:01:09 +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 1r8L7k-00AtwN-CM for pgsql-docs@arkaria.postgresql.org; Wed, 29 Nov 2023 14:01:08 +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 1r8L7k-00AtwF-3E for pgsql-docs@lists.postgresql.org; Wed, 29 Nov 2023 14:01:08 +0000 Received: from out2-smtp.messagingengine.com ([66.111.4.26]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1r8L7f-009B8Z-Kg for pgsql-docs@lists.postgresql.org; Wed, 29 Nov 2023 14:01:07 +0000 Received: from compute5.internal (compute5.nyi.internal [10.202.2.45]) by mailout.nyi.internal (Postfix) with ESMTP id 19BCF5C0185; Wed, 29 Nov 2023 09:01:02 -0500 (EST) Received: from mailfrontend1 ([10.202.2.162]) by compute5.internal (MEProxy); Wed, 29 Nov 2023 09:01:02 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=eisentraut.org; h=cc:content-type:content-type:date:date:from:from:in-reply-to :in-reply-to:message-id:mime-version:references:reply-to:sender :subject:subject:to:to; s=fm3; t=1701266462; x=1701352862; bh=Zj O0x4B8qqnorInRc1ULp8ngI+TCCTa9R1zlq7inJwk=; b=flUt6a7iBDaWs/hfQH MDcmWKnVRNbpS9VaOq/csCgVwJ4VzmDS0pChJjxHRtrO3PUyuIX/ytF8pkFkdLt2 0kPccT1tuGD2AABY+O0TI4iVaSfX39k4ni/8vi0qcUh7SYmLRXE6nnPTEdOTQdm9 Z5gWt1O+91OEfm5L9VYVWqSb03VUNhc8bpFzdT7mQTUQWPmhfaWnoh7jo99dF6VR i1sHMG5mc1OW+VYEI6DOqKXJrNbCd5Axs9kYH8avzomAmZz2HELLp/sN/9d5VOLU z3RrN+Q80j3T85luA5j6HuHW0RGzWo8JoDZd1pYGmh4L/s4X0uBzq5yUcm1fFlZ1 /ycg== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:content-type:date:date :feedback-id:feedback-id:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:sender:subject :subject:to:to:x-me-proxy:x-me-proxy:x-me-sender:x-me-sender :x-sasl-enc; s=fm1; t=1701266462; x=1701352862; bh=ZjO0x4B8qqnor InRc1ULp8ngI+TCCTa9R1zlq7inJwk=; b=1Pxg+8ZgIZFOFUC6/MPafquwtLBi1 ekMCSE/Jt7Y5/Ywu7T6aoGq3jJtCVmfK5d4dg0K68/Xr/jkczXYXCG/v/2dXNzih KRVZECymamgQ+aw/SFM7YcgZBG1PXLdCyom5yqHWxGkCwQm8BVQS0SRhjQzXnfUQ 2cREF+8VmL6naPaBiURG7PWEJIrr0+wa2/qaNdGNYV0b7EWYA5UR+R9c53ioWQj3 Yk3OzFAEP9ZanR9bYQGnq89V2GT4q/AbtXqruRSHqFGlX3cCvU0+slPDcuoDHftr yIlP1RHyMIz5+aXy2F3uBZPD8zZFsnpgN+ZWXhJiSm5f4uig7dRj2802A== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvkedrudeihedgheejucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne cujfgurheptgfkffggfgfuvfhfhfgjsehmtderredtvdejnecuhfhrohhmpefrvghtvghr ucfgihhsvghnthhrrghuthcuoehpvghtvghrsegvihhsvghnthhrrghuthdrohhrgheqne cuggftrfgrthhtvghrnhepvddtfedtjefgvddtkeejhfdukeffgeelgfehlefgkeetteet udejkeeihfekueffnecuffhomhgrihhnpehpohhsthhgrhgvshhqlhdrohhrghenucevlh hushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpehpvghtvghrsegv ihhsvghnthhrrghuthdrohhrgh X-ME-Proxy: Feedback-ID: ie0a040ee:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Wed, 29 Nov 2023 09:01:01 -0500 (EST) Content-Type: multipart/mixed; boundary="------------qxokel2EeJsN1m1nLR0mtNjM" Message-ID: <28163ed6-e3aa-49b3-8053-02f6c145f02f@eisentraut.org> Date: Wed, 29 Nov 2023 15:01:00 +0100 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: INFORMATION_SCHEMA.routine_column_usage Content-Language: en-US To: Erki Eessaar , "pgsql-docs@lists.postgresql.org" References: From: Peter Eisentraut In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------qxokel2EeJsN1m1nLR0mtNjM Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit > Here > https://www.postgresql.org/docs/current/infoschema-routine-column-usage.html > > it is stated that "The view |routine_column_usage| is meant to identify > all columns that are used by a function or procedure. This information > is currently not tracked by PostgreSQL." > > However, this claim is incorrect because the view provides information > about the column usage of SQL functions that have SQL-standard function > body. Correct, the documentation was not updated when this was added. A few other views are similarly affected. How about this attached patch. --------------qxokel2EeJsN1m1nLR0mtNjM Content-Type: text/plain; charset=UTF-8; name="0001-doc-Update-info-on-information-schema-usage-tables.patch" Content-Disposition: attachment; filename*0="0001-doc-Update-info-on-information-schema-usage-tables.patc"; filename*1="h" Content-Transfer-Encoding: base64 RnJvbSBkZmU2NWFjZTI3YTViMmUxMTUxMWU1ZDkyOWVlYTM1NmM4Y2E4OWU1IE1vbiBTZXAg MTcgMDA6MDA6MDAgMjAwMQpGcm9tOiBQZXRlciBFaXNlbnRyYXV0IDxwZXRlckBlaXNlbnRy YXV0Lm9yZz4KRGF0ZTogV2VkLCAyOSBOb3YgMjAyMyAxNDo1Njo0MSArMDEwMApTdWJqZWN0 OiBbUEFUQ0hdIGRvYzogVXBkYXRlIGluZm8gb24gaW5mb3JtYXRpb24gc2NoZW1hIHVzYWdl IHRhYmxlcwoKQ29tbWl0IGY0MGM2OTY5ZDAgYWRkZWQgdGhlIGluZm9ybWF0aW9uIHNjaGVt YSB1c2FnZSB0YWJsZXMgYnV0IGFkZGVkCmRvY3VtZW50YXRpb24gdGhhdCB0aGV5IGRpZCBu b3QgZnVsbHkgd29yayB5ZXQuICBDb21taXQgZTcxN2E5YTE4Ygp0aGVuIGFkZGVkIFNRTC1z dGFuZGFyZCBmdW5jdGlvbiBib2RpZXMsIHdoaWNoIG1hZGUgdGhlIGluZm9ybWF0aW9uCnNj aGVtYSB2aWV3cyBmdWxseSBmdW5jdGlvbmFsLCBidXQgaXQgbmVnbGVjdGVkIHRvIHVwZGF0 ZSB0aGUKZG9jdW1lbnRhdGlvbi4gIFRoaXMgaXMgbm93IGRvbmUgaGVyZS4KClJlcG9ydGVk LWJ5OiBFcmtpIEVlc3NhYXIgPGVya2kuZWVzc2FhckB0YWx0ZWNoLmVlPgpEaXNjdXNzaW9u OiBodHRwczovL3d3dy5wb3N0Z3Jlc3FsLm9yZy9tZXNzYWdlLWlkL2ZsYXQvQU05UFIwMU1C ODI2OEVDN0I2OTZGOUZFMzQ2Q0E1QjkzRkVCOEElNDBBTTlQUjAxTUI4MjY4LmV1cnByZDAx LnByb2QuZXhjaGFuZ2VsYWJzLmNvbQoKVE9ETzogYmFja3BhdGNoIDE0KwotLS0KIGRvYy9z cmMvc2dtbC9pbmZvcm1hdGlvbl9zY2hlbWEuc2dtbCB8IDMwICsrKysrKysrKysrKysrKy0t LS0tLS0tLS0tLS0KIDEgZmlsZSBjaGFuZ2VkLCAxNiBpbnNlcnRpb25zKCspLCAxNCBkZWxl dGlvbnMoLSkKCmRpZmYgLS1naXQgYS9kb2Mvc3JjL3NnbWwvaW5mb3JtYXRpb25fc2NoZW1h LnNnbWwgYi9kb2Mvc3JjL3NnbWwvaW5mb3JtYXRpb25fc2NoZW1hLnNnbWwKaW5kZXggOWMz OWU5YWFiNS4uMGNhN2Q1YTllMCAxMDA2NDQKLS0tIGEvZG9jL3NyYy9zZ21sL2luZm9ybWF0 aW9uX3NjaGVtYS5zZ21sCisrKyBiL2RvYy9zcmMvc2dtbC9pbmZvcm1hdGlvbl9zY2hlbWEu c2dtbApAQCAtNDg0Niw5ICs0ODQ2LDExIEBAIDx0aXRsZT48c3RydWN0bmFtZT5yb2xlX3Vz YWdlX2dyYW50czwvc3RydWN0bmFtZT4gQ29sdW1uczwvdGl0bGU+CiAgIDx0aXRsZT48bGl0 ZXJhbD5yb3V0aW5lX2NvbHVtbl91c2FnZTwvbGl0ZXJhbD48L3RpdGxlPgogCiAgIDxwYXJh PgotICAgVGhlIHZpZXcgPGxpdGVyYWw+cm91dGluZV9jb2x1bW5fdXNhZ2U8L2xpdGVyYWw+ IGlzIG1lYW50IHRvIGlkZW50aWZ5IGFsbAotICAgY29sdW1ucyB0aGF0IGFyZSB1c2VkIGJ5 IGEgZnVuY3Rpb24gb3IgcHJvY2VkdXJlLiAgVGhpcyBpbmZvcm1hdGlvbiBpcwotICAgY3Vy cmVudGx5IG5vdCB0cmFja2VkIGJ5IDxwcm9kdWN0bmFtZT5Qb3N0Z3JlU1FMPC9wcm9kdWN0 bmFtZT4uCisgICBUaGUgdmlldyA8bGl0ZXJhbD5yb3V0aW5lX2NvbHVtbl91c2FnZTwvbGl0 ZXJhbD4gaWRlbnRpZmllcyBhbGwgY29sdW1ucworICAgdGhhdCBhcmUgdXNlZCBieSBhIGZ1 bmN0aW9uIG9yIHByb2NlZHVyZSwgZWl0aGVyIGluIHRoZSBTUUwgYm9keSBvciBpbgorICAg cGFyYW1ldGVyIGRlZmF1bHQgZXhwcmVzc2lvbnMuICAoVGhpcyBvbmx5IHdvcmtzIGZvciB1 bnF1b3RlZCBTUUwgYm9kaWVzLAorICAgbm90IHF1b3RlZCBib2RpZXMgb3IgZnVuY3Rpb25z IGluIG90aGVyIGxhbmd1YWdlcy4pICBBIGNvbHVtbiBpcyBvbmx5CisgICBpbmNsdWRlZCBp ZiBpdHMgdGFibGUgaXMgb3duZWQgYnkgYSBjdXJyZW50bHkgZW5hYmxlZCByb2xlLgogICA8 L3BhcmE+CiAKICAgPHRhYmxlPgpAQCAtNTA4NSwxMiArNTA4NywxMiBAQCA8dGl0bGU+PHN0 cnVjdG5hbWU+cm91dGluZV9wcml2aWxlZ2VzPC9zdHJ1Y3RuYW1lPiBDb2x1bW5zPC90aXRs ZT4KICAgPHRpdGxlPjxsaXRlcmFsPnJvdXRpbmVfcm91dGluZV91c2FnZTwvbGl0ZXJhbD48 L3RpdGxlPgogCiAgIDxwYXJhPgotICAgVGhlIHZpZXcgPGxpdGVyYWw+cm91dGluZV9yb3V0 aW5lX3VzYWdlPC9saXRlcmFsPiBpcyBtZWFudCB0byBpZGVudGlmeSBhbGwKLSAgIGZ1bmN0 aW9ucyBvciBwcm9jZWR1cmVzIHRoYXQgYXJlIHVzZWQgYnkgYW5vdGhlciAob3IgdGhlIHNh bWUpIGZ1bmN0aW9uIG9yCi0gICBwcm9jZWR1cmUsIGVpdGhlciBpbiB0aGUgYm9keSBvciBp biBwYXJhbWV0ZXIgZGVmYXVsdCBleHByZXNzaW9ucy4KLSAgIEN1cnJlbnRseSwgb25seSBm dW5jdGlvbnMgdXNlZCBpbiBwYXJhbWV0ZXIgZGVmYXVsdCBleHByZXNzaW9ucyBhcmUKLSAg IHRyYWNrZWQuICBBbiBlbnRyeSBpcyBpbmNsdWRlZCBoZXJlIG9ubHkgaWYgdGhlIHVzZWQg ZnVuY3Rpb24gaXMgb3duZWQgYnkgYQotICAgY3VycmVudGx5IGVuYWJsZWQgcm9sZS4gIChU aGVyZSBpcyBubyBzdWNoIHJlc3RyaWN0aW9uIG9uIHRoZSB1c2luZworICAgVGhlIHZpZXcg PGxpdGVyYWw+cm91dGluZV9yb3V0aW5lX3VzYWdlPC9saXRlcmFsPiBpZGVudGlmaWVzIGFs bCBmdW5jdGlvbnMKKyAgIG9yIHByb2NlZHVyZXMgdGhhdCBhcmUgdXNlZCBieSBhbm90aGVy IChvciB0aGUgc2FtZSkgZnVuY3Rpb24gb3IgcHJvY2VkdXJlLAorICAgZWl0aGVyIGluIHRo ZSBTUUwgYm9keSBvciBpbiBwYXJhbWV0ZXIgZGVmYXVsdCBleHByZXNzaW9ucy4gIChUaGlz IG9ubHkKKyAgIHdvcmtzIGZvciB1bnF1b3RlZCBTUUwgYm9kaWVzLCBub3QgcXVvdGVkIGJv ZGllcyBvciBmdW5jdGlvbnMgaW4gb3RoZXIKKyAgIGxhbmd1YWdlcy4pICBBbiBlbnRyeSBp cyBpbmNsdWRlZCBoZXJlIG9ubHkgaWYgdGhlIHVzZWQgZnVuY3Rpb24gaXMgb3duZWQKKyAg IGJ5IGEgY3VycmVudGx5IGVuYWJsZWQgcm9sZS4gIChUaGVyZSBpcyBubyBzdWNoIHJlc3Ry aWN0aW9uIG9uIHRoZSB1c2luZwogICAgZnVuY3Rpb24uKQogICA8L3BhcmE+CiAKQEAgLTUx ODQsMTEgKzUxODYsMTEgQEAgPHRpdGxlPjxsaXRlcmFsPnJvdXRpbmVfcm91dGluZV91c2Fn ZTwvbGl0ZXJhbD4gQ29sdW1uczwvdGl0bGU+CiAgIDx0aXRsZT48bGl0ZXJhbD5yb3V0aW5l X3NlcXVlbmNlX3VzYWdlPC9saXRlcmFsPjwvdGl0bGU+CiAKICAgPHBhcmE+Ci0gICBUaGUg dmlldyA8bGl0ZXJhbD5yb3V0aW5lX3NlcXVlbmNlX3VzYWdlPC9saXRlcmFsPiBpcyBtZWFu dCB0byBpZGVudGlmeSBhbGwKLSAgIHNlcXVlbmNlcyB0aGF0IGFyZSB1c2VkIGJ5IGEgZnVu Y3Rpb24gb3IgcHJvY2VkdXJlLCBlaXRoZXIgaW4gdGhlIGJvZHkgb3IKLSAgIGluIHBhcmFt ZXRlciBkZWZhdWx0IGV4cHJlc3Npb25zLiAgQ3VycmVudGx5LCBvbmx5IHNlcXVlbmNlcyB1 c2VkIGluCi0gICBwYXJhbWV0ZXIgZGVmYXVsdCBleHByZXNzaW9ucyBhcmUgdHJhY2tlZC4g IEEgc2VxdWVuY2UgaXMgb25seSBpbmNsdWRlZCBpZgotICAgdGhhdCBzZXF1ZW5jZSBpcyBv d25lZCBieSBhIGN1cnJlbnRseSBlbmFibGVkIHJvbGUuCisgICBUaGUgdmlldyA8bGl0ZXJh bD5yb3V0aW5lX3NlcXVlbmNlX3VzYWdlPC9saXRlcmFsPiBpZGVudGlmaWVzIGFsbCBzZXF1 ZW5jZXMKKyAgIHRoYXQgYXJlIHVzZWQgYnkgYSBmdW5jdGlvbiBvciBwcm9jZWR1cmUsIGVp dGhlciBpbiB0aGUgU1FMIGJvZHkgb3IgaW4KKyAgIHBhcmFtZXRlciBkZWZhdWx0IGV4cHJl c3Npb25zLiAgKFRoaXMgb25seSB3b3JrcyBmb3IgdW5xdW90ZWQgU1FMIGJvZGllcywKKyAg IG5vdCBxdW90ZWQgYm9kaWVzIG9yIGZ1bmN0aW9ucyBpbiBvdGhlciBsYW5ndWFnZXMuKSAg QSBzZXF1ZW5jZSBpcyBvbmx5CisgICBpbmNsdWRlZCBpZiB0aGF0IHNlcXVlbmNlIGlzIG93 bmVkIGJ5IGEgY3VycmVudGx5IGVuYWJsZWQgcm9sZS4KICAgPC9wYXJhPgogCiAgIDx0YWJs ZT4KLS0gCjIuNDMuMAoK --------------qxokel2EeJsN1m1nLR0mtNjM--