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 1o40T6-0002A3-0M for pgsql-hackers@arkaria.postgresql.org; Wed, 22 Jun 2022 13:32:28 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1o40T4-0000Ge-E5 for pgsql-hackers@arkaria.postgresql.org; Wed, 22 Jun 2022 13:32:26 +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 1o40T4-0000Fu-4N for pgsql-hackers@lists.postgresql.org; Wed, 22 Jun 2022 13:32:26 +0000 Received: from smtp-fw-80007.amazon.com ([99.78.197.218]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1o40T0-0007oi-UO for pgsql-hackers@postgresql.org; Wed, 22 Jun 2022 13:32:25 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=amazon.com; i=@amazon.com; q=dns/txt; s=amazon201209; t=1655904742; x=1687440742; h=message-id:date:mime-version:subject:to:cc:references: from:in-reply-to:content-transfer-encoding; bh=UwkYRI9141n/oBeWFhbhM+HVugx4mydFpqghfHhgK4g=; b=p1VqyB0JVlLRejdjHpgwXNctloAXktTS/MJuewNXSVpSpogFesd8fxbt WBk4+EbuIu0NYlnA4gaHgyk01GdXE8gCqzcP4smF3A3Dggn7O4j6xX/s9 AoyalNZet8Pkg1BhgM0wOMwhVbm0IRl2m7GFCnDp7Zmuh7Ph6uBUJ6/Gk w=; X-IronPort-AV: E=Sophos;i="5.92,212,1650931200"; d="scan'208";a="100756822" Received: from pdx4-co-svc-p1-lb2-vlan2.amazon.com (HELO email-inbound-relay-iad-1box-d-0e176545.us-east-1.amazon.com) ([10.25.36.210]) by smtp-border-fw-80007.pdx80.corp.amazon.com with ESMTP; 22 Jun 2022 13:31:26 +0000 Received: from EX13D03EUC003.ant.amazon.com (iad12-ws-svc-p26-lb9-vlan2.iad.amazon.com [10.40.163.34]) by email-inbound-relay-iad-1box-d-0e176545.us-east-1.amazon.com (Postfix) with ESMTPS id 28CEB81CA0; Wed, 22 Jun 2022 13:31:24 +0000 (UTC) Received: from [192.168.18.187] (10.43.160.26) by EX13D03EUC003.ant.amazon.com (10.43.164.192) with Microsoft SMTP Server (TLS) id 15.0.1497.36; Wed, 22 Jun 2022 13:31:21 +0000 Message-ID: Date: Wed, 22 Jun 2022 15:31:16 +0200 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:91.0) Gecko/20100101 Thunderbird/91.10.0 Subject: Re: [PATCH] Expose port->authn_id to extensions and triggers Content-Language: en-US To: Jacob Champion , Robert Haas CC: Tom Lane , Michael Paquier , "sfrost@snowman.net" , "rjuju123@gmail.com" , "pgsql-hackers@postgresql.org" , "andres@anarazel.de" References: <20220329235332.z4q5hgv7jsmcavzv@alap3.anarazel.de> <6f7d988668974bb6c0078f6c026b456cd79ae314.camel@vmware.com> <300712f85a30acecaa5c8f16c968b95537bfebd8.camel@vmware.com> <200677.1654265052@sss.pgh.pa.us> From: "Drouvot, Bertrand" In-Reply-To: Content-Type: text/plain; charset="UTF-8"; format=flowed Content-Transfer-Encoding: 7bit X-Originating-IP: [10.43.160.26] X-ClientProxiedBy: EX13D36UWB001.ant.amazon.com (10.43.161.84) To EX13D03EUC003.ant.amazon.com (10.43.164.192) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, On 6/10/22 7:58 PM, Jacob Champion wrote: > CAUTION: This email originated from outside of the organization. Do not click links or open attachments unless you can confirm the sender and know the content is safe. > > > > On Thu, Jun 9, 2022 at 6:23 AM Robert Haas wrote: >> On Wed, Jun 8, 2022 at 7:53 PM Jacob Champion wrote: >>> But I don't have any better ideas for how to achieve both. I'm fine >>> with your suggestion of ClientConnectionInfo, if that sounds good to >>> others; the doc comment can clarify why it differs from Port? Or add >>> one of the Shared-/Gang-/Group- prefixes to it, maybe? >> I don't like the prefixes, so I'd prefer explaining it in the struct comment. > Done that way in v11. > > Thanks! > --Jacob FWIW, I just created a new thread to expose the port->authn_id through the SYSTEM_USER sql reserved word. Regards, Bertrand