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 1sf9Yk-002EPq-N1 for pgsql-docs@arkaria.postgresql.org; Sat, 17 Aug 2024 02:52:54 +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 1sf9Yi-001ybz-Hj for pgsql-docs@arkaria.postgresql.org; Sat, 17 Aug 2024 02:52:53 +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 1sf9Yi-001ybi-A4 for pgsql-docs@lists.postgresql.org; Sat, 17 Aug 2024 02:52:53 +0000 Received: from momjian.us ([72.94.173.45]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sf9Ye-0002pS-Ud for pgsql-docs@lists.postgresql.org; Sat, 17 Aug 2024 02:52:52 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=momjian.us; s=2024011501; h=In-Reply-To:Content-Type:MIME-Version:References:Message-ID: Subject:To:From:Date:Sender:Reply-To:Cc:Content-Transfer-Encoding:Content-ID: Content-Description; bh=m2vyIVCEayy8HmrI53iQadiN416jSdqnnUIyTWlUFMg=; b=gPcu5 HzCPZ0olMTyLmp1D711Y3DVmFF2+uVkfG4UNaFJ7U32Sb+vGNiYtbHvjZqr4VJdw3m0pIJ/BNbfGR DD570Ar/vnhpw50iaCwtVgT6JhgHmCl0TytfJdre50m7XprpvmIpuZvbnO2pVWaa5TV6zOecieAEX 6KjNyOs/RZ6xrtL0MsFAln9MUkCFOiK26INnyierQclis0mTfgQkGnX6zb8XMMR0FdTWf23AsuFZh MiyfNrhHeYhVTnuh3lHX4AlYnSQg4CrnDjEMxqwVuzK/fNqHs1n/An2tKFN/uFaGr30FaV9vshP7S cCM+J6xlVZ7NhH3SUlM2UIVVUuEtA==; Received: from bruce by momjian.us with local (Exim 4.96) (envelope-from ) id 1sf9Yf-004qBR-0L; Fri, 16 Aug 2024 22:52:49 -0400 Date: Fri, 16 Aug 2024 22:52:49 -0400 From: Bruce Momjian To: philipp.salvisberg@gmail.com, pgsql-docs@lists.postgresql.org Subject: Re: Change detail text in last example of 43.5.3. Executing a Command with a Single-Row Result Message-ID: References: <172112109590.736590.12219129462878821880@wrigleys.postgresql.org> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <172112109590.736590.12219129462878821880@wrigleys.postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, Jul 16, 2024 at 09:11:35AM +0000, PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/16/plpgsql-statements.html > Description: > > The last example in the chapter uses a named parameter "username". As a > result, the detail message should use "username" instead of "$1" to match > the runtime behavior. > > I suggest to change this line > > DETAIL: parameters: $1 = 'nosuchuser' > > to > > DETAIL: parameters: username = 'nosuchuser' Wow, this error goes all the way back to Postgres 12, which is our earliest supported release. I have patched all our supported releases with this fix. Thanks. -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Only you can decide what is important to you.