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 1oTYkS-0006sA-Ft for pgsql-docs@arkaria.postgresql.org; Thu, 01 Sep 2022 01:12:00 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oTYkR-0002Vw-EK for pgsql-docs@arkaria.postgresql.org; Thu, 01 Sep 2022 01:11:59 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oTYkR-0002VN-8W for pgsql-docs@lists.postgresql.org; Thu, 01 Sep 2022 01:11:59 +0000 Received: from momjian.us ([72.94.173.45]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oTYkO-0002cU-0o for pgsql-docs@lists.postgresql.org; Thu, 01 Sep 2022 01:11:58 +0000 Received: from bruce by momjian.us with local (Exim 4.94.2) (envelope-from ) id 1oTYkK-005E3U-9a; Wed, 31 Aug 2022 21:11:52 -0400 Date: Wed, 31 Aug 2022 21:11:52 -0400 From: Bruce Momjian To: Tom Lane Cc: Erki Eessaar , "pgsql-docs@lists.postgresql.org" Subject: Re: SQL-standard function bodies and creating SECURITY DEFINER routines securely Message-ID: References: <1408823.1660678462@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, Aug 16, 2022 at 03:38:13PM -0400, Bruce Momjian wrote: > On Tue, Aug 16, 2022 at 03:34:22PM -0400, Tom Lane wrote: > > Bruce Momjian writes: > > > I have written the attached patch to mention this issue about sql_body > > > functions. > > > > Spell-check, please. Seems OK otherwise. > > Just when I think I didn't add enough text to warrant a spell check. > :-( Updated patch attached. Patch applied back to PG 10. Thanks. -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Indecision is a decision. Inaction is an action. Mark Batterson