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 1uHUE7-0038iJ-56 for pgsql-hackers@arkaria.postgresql.org; Tue, 20 May 2025 21:10:19 +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 1uHUE5-009CFg-LO for pgsql-hackers@arkaria.postgresql.org; Tue, 20 May 2025 21:10:17 +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 1uHUE5-009CFL-Ah for pgsql-hackers@lists.postgresql.org; Tue, 20 May 2025 21:10:17 +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.96) (envelope-from ) id 1uHUE2-0000TD-2p for pgsql-hackers@lists.postgresql.org; Tue, 20 May 2025 21:10:17 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=momjian.us; s=2025010100; h=In-Reply-To:Content-Transfer-Encoding:Content-Type: MIME-Version:References:Message-ID:Subject:Cc:To:From:Date:Sender:Reply-To: Content-ID:Content-Description; bh=5rRtRuZtXDiL3AdwqCSjUN3fkFVM/xTxdjEBeneYH8Q=; b=pn/pWU9OwKNf4kZYV3bmUhc+b4 3F/8UM4Ji/9afHDpGX8iLnWwDXtSqtBlwMbtYmLTBBl8FZkVzMJqe4FiKhXx0FdlXtPohAA7L9VHC aLdvDYKZUqaQM8B+NZQFGpVHzCZltEtEVdlcBmR1dmGhWqqSLUHtuDFDPD4OapGngW29qvW5E9rPJ 7pSmYuwoMTz0eE0Lo6cq9Xett0JeAs2h0uLAvrZmS6BzSAY1GjB5dXeABBb/+kw593y6vpdxJPr7Y LJbYzsUcWf/uKgclrvEq873jnuRWIA7hANJPEKOhmDYapo94jU7JEPk47shqEYInr4Z2zBPTTeNgI 3Z3xSmjw==; Received: from bruce by momjian.us with local (Exim 4.96) (envelope-from ) id 1uHUDx-005JCD-2k; Tue, 20 May 2025 17:10:09 -0400 Date: Tue, 20 May 2025 17:10:09 -0400 From: Bruce Momjian To: Pavel Stehule Cc: Marcos Pegoraro , jian he , Dmitry Dolgov <9erthalion6@gmail.com>, Laurenz Albe , Erik Rijkers , Michael Paquier , Amit Kapila , DUVAL REMI , PostgreSQL Hackers Subject: Re: Re: proposal: schema variables Message-ID: References: MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, May 20, 2025 at 10:28:31PM +0200, Pavel Stehule wrote: > út 20. 5. 2025 v 18:39 odesílatel Bruce Momjian napsal: > I sent a reduced version a few months ago - from 21 patches to 8 (and it can be > reduced to six if we postpone tools for detection ambiguity). > The timing was not perfect - the focus was and it is concentrated to finish > pg18. It was not clear to me that this patch set was being reduced to make it more likely it would be accepted? I thought it was the same patch set since 20??. > I am very sorry if this topic and patches bother anyone. I am afraid if I close > it to some personal github, it will not be visible, and I am sure this > feature is missing in Postgres. Today we have few workarounds. Some workarounds > are not available everywhere, some workarounds cannot > be used for security. With integrated solutions some scenarios can be done more > easily, more secure, faster, more comfortable.  It is true, so > mentioned scenarios are not "hot" today. Stored procedures or RLS or migration > procedures from other databases are not extra common. But > who uses it, then he misses session variables. Understood. If people feel it is progressing toward acceptance, I certainly withdraw my objection and apologize. -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Do not let urgent matters crowd out time for investment in the future.