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 1pC2z3-0001Tt-1v for pgsql-committers@arkaria.postgresql.org; Sun, 01 Jan 2023 18:22:57 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pC2z1-0001P0-RD for pgsql-committers@arkaria.postgresql.org; Sun, 01 Jan 2023 18:22:55 +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 1pC2z1-0001Or-K5 for pgsql-committers@lists.postgresql.org; Sun, 01 Jan 2023 18:22:55 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pC2yx-0005ik-GO for pgsql-committers@lists.postgresql.org; Sun, 01 Jan 2023 18:22:55 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pC2yv-0000Dg-O4 for pgsql-committers@lists.postgresql.org; Sun, 01 Jan 2023 18:22:49 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1pC2yu-001Ydg-Ee for pgsql-committers@lists.postgresql.org; Sun, 01 Jan 2023 18:22:48 +0000 Content-Type: multipart/mixed; boundary="===============5677815767312200173==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: In plpgsql, don't preassign portal names to bound cursor variabl X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Sun, 01 Jan 2023 18:22:48 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============5677815767312200173== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 SW4gcGxwZ3NxbCwgZG9uJ3QgcHJlYXNzaWduIHBvcnRhbCBuYW1lcyB0byBib3VuZCBjdXJzb3Ig dmFyaWFibGVzLgoKQSByZWZjdXJzb3IgdmFyaWFibGUgdGhhdCBpcyBib3VuZCB0byBhIHNwZWNp ZmljIHF1ZXJ5IChieSBkZWNsYXJpbmcKaXQgd2l0aCAiQ1VSU09SIEZPUiIpIG5vdyBjaG9vc2Vz IGEgcG9ydGFsIG5hbWUgaW4gdGhlIHNhbWUgd2F5IGFzIGFuCnVuYm91bmQsIHBsYWluIHJlZmN1 cnNvciB2YXJpYWJsZS4gIEl0cyBzdHJpbmcgdmFsdWUgc3RhcnRzIG91dCBhcwpOVUxMLCBhbmQg dW5sZXNzIHRoYXQncyBvdmVycmlkZGVuIGJ5IG1hbnVhbCBhc3NpZ25tZW50LCBpdCB3aWxsIGJl CnJlcGxhY2VkIGJ5IGEgdW5pcXVlLXdpdGhpbi1zZXNzaW9uIHBvcnRhbCBuYW1lIGR1cmluZyBP UEVOLgoKVGhlIHByZXZpb3VzIGJlaGF2aW9yIHdhcyB0byBpbml0aWFsaXplIHN1Y2ggdmFyaWFi bGVzIHRvIGNvbnRhaW4KdGhlaXIgb3duIG5hbWUsIHJlc3VsdGluZyBpbiB0aGF0IGFsc28gYmVp bmcgdGhlIHBvcnRhbCBuYW1lIHVubGVzcwp0aGUgdXNlciBvdmVyd3JvdGUgaXQgYmVmb3JlIE9Q RU4uICBUaGUgdHJvdWJsZSB3aXRoIHRoaXMgaXMgdGhhdAppdCBjYXVzZXMgZmFpbHVyZXMgZHVl IHRvIGNvbmZsaWN0aW5nIHBvcnRhbCBuYW1lcyBpZiB0aGUgc2FtZQpjdXJzb3IgdmFyaWFibGUg bmFtZSBpcyB1c2VkIGluIGRpZmZlcmVudCBmdW5jdGlvbnMuICBJdCBpcyBwcmV0dHkKbm9uLW9y dGhvZ29uYWwgdG8gaGF2ZSBib3VuZCBhbmQgdW5ib3VuZCByZWZjdXJzb3IgdmFyaWFibGVzIGJl aGF2ZQpkaWZmZXJlbnRseSBvbiB0aGlzIHBvaW50LCB0b28sIHNvIGxldCdzIGNoYW5nZSBpdC4K ClRoaXMgY2hhbmdlIGNhbiBjYXVzZSBjb21wYXRpYmlsaXR5IHByb2JsZW1zIGZvciBhcHBsaWNh dGlvbnMgdGhhdApvcGVuIGEgYm91bmQgY3Vyc29yIGluIGEgcGxwZ3NxbCBmdW5jdGlvbiBhbmQg dGhlbiB1c2UgaXQgaW4gdGhlCmNhbGxpbmcgY29kZSB3aXRob3V0IGV4cGxpY2l0bHkgcGFzc2lu ZyBiYWNrIHRoZSByZWZjdXJzb3IgdmFsdWUKKHBvcnRhbCBuYW1lKS4gIElmIHRoZSBjYWxsaW5n IGNvZGUgc2ltcGx5IGFzc3VtZXMgdGhhdCB0aGUgcG9ydGFsCm5hbWUgbWF0Y2hlcyB0aGUgY2Fs bGVkIGZ1bmN0aW9uJ3MgdmFyaWFibGUgbmFtZSwgaXQgd2lsbCBub3cgZmFpbC4KVGhhdCBjYW4g YmUgZml4ZWQgYnkgZXhwbGljaXRseSBhc3NpZ25pbmcgYSBzdHJpbmcgdmFsdWUgdG8gdGhlCnJl ZmN1cnNvciB2YXJpYWJsZSBiZWZvcmUgT1BFTiwgZS5nLgoKICAgIERFQ0xBUkUgbXljIENVUlNP UiBGT1IgU0VMRUNUIC4uLjsKICAgIEJFR0lOCiAgICAgIG15YyA6PSAnbXljJzsgIC0tIGFkZCB0 aGlzCiAgICAgIE9QRU4gbXljOwoKV2UgaGF2ZSBubyBkb2N1bWVudGF0aW9uIGV4YW1wbGVzIHNo b3dpbmcgdGhlIHRyb3VibGVzb21lIHVzYWdlCnBhdHRlcm4sIHNvIHdlIGNhbiBob3BlIGl0J3Mg cmFyZSBpbiBwcmFjdGljZS4KClBhdGNoIGJ5IG1lOyB0aGFua3MgdG8gUGF2ZWwgU3RlaHVsZSBh bmQgSmFuIFdpZWNrIGZvciByZXZpZXcuCgpEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5lcy9t LzE0NjUxMDEuMTY2NzM0NTk4M0Bzc3MucGdoLnBhLnVzCgpCcmFuY2gKLS0tLS0tCm1hc3RlcgoK RGV0YWlscwotLS0tLS0tCmh0dHBzOi8vZ2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1pdGRpZmYv ZDc0N2RjODVhZWM1MzZjNDcxZmQ3YzczOTY5NWUxNTU2MjdiMDhmZAoKTW9kaWZpZWQgRmlsZXMK LS0tLS0tLS0tLS0tLS0KZG9jL3NyYy9zZ21sL3BscGdzcWwuc2dtbCAgICAgICAgICAgICB8IDQy ICsrKysrKysrKysrKysrKysrKysrKysrKysrLS0tLS0tLS0tCmRvYy9zcmMvc2dtbC9yZWYvZGVj bGFyZS5zZ21sICAgICAgICAgfCAxNiArKysrKysrKysrKysrCnNyYy9wbC9wbHBnc3FsL3NyYy9w bF9ncmFtLnkgICAgICAgICAgfCAyNyAtLS0tLS0tLS0tLS0tLS0tLS0tLS0tCnNyYy90ZXN0L3Jl Z3Jlc3MvZXhwZWN0ZWQvcGxwZ3NxbC5vdXQgfCAxOSArKysrKysrKysrKysrKysrCnNyYy90ZXN0 L3JlZ3Jlc3Mvc3FsL3BscGdzcWwuc3FsICAgICAgfCAyMCArKysrKysrKysrKysrKysrKwo1IGZp bGVzIGNoYW5nZWQsIDg3IGluc2VydGlvbnMoKyksIDM3IGRlbGV0aW9ucygtKQoK --===============5677815767312200173==--