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 1tnGcX-003i0q-FH for pgsql-hackers@arkaria.postgresql.org; Wed, 26 Feb 2025 12:34:38 +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 1tnGcW-004vlJ-Cr for pgsql-hackers@arkaria.postgresql.org; Wed, 26 Feb 2025 12:34:36 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tnGcV-004vlA-LU for pgsql-hackers@lists.postgresql.org; Wed, 26 Feb 2025 12:34:36 +0000 Received: from fhigh-a4-smtp.messagingengine.com ([103.168.172.155]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1tnGcS-000BZG-1T for pgsql-hackers@postgresql.org; Wed, 26 Feb 2025 12:34:34 +0000 Received: from phl-compute-03.internal (phl-compute-03.phl.internal [10.202.2.43]) by mailfhigh.phl.internal (Postfix) with ESMTP id 023CE114016D; Wed, 26 Feb 2025 07:34:32 -0500 (EST) Received: from phl-mailfrontend-02 ([10.202.2.163]) by phl-compute-03.internal (MEProxy); Wed, 26 Feb 2025 07:34:32 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ilmari.org; h=cc :cc:content-type:content-type:date:date:from:from:in-reply-to :in-reply-to:message-id:mime-version:references:reply-to:subject :subject:to:to; s=fm3; t=1740573271; x=1740659671; bh=mkfIwgWKTS Q8W177sqVs2/IANY7WvUftCyCsjig8L0k=; b=jcqC3mqKZ1KtpKX1U+gV/7WTD/ CEgbbp3SB9+X6rAEgijUatII4Ltht7HtNYN8CnP6y7TS6YjxMkhsYA7FmtEKT0na T3ZfNj9/z+d3xNYP7SvzDZtJRGljoCERkbr+O4ocqh3GM22KEk8ShYmKQ7qO/tST k8KTa8OcRzpRoCZpBUNLj71Jha5Ec01S3pylNSHGgr5OwKQ4eFSqo+D09uzC7SHH ZnfQQth0akJ61eKvoMBPMiAfDsKpFS6nLtv5iKTzArqGLCupBwrFFx1l/or4snn5 4eqmr6yRTayCmY6z0Df9QNueBHPwlYojLNqTxE/ln3F0SnyIDLb9m+rSpNBQ== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-type:content-type:date:date :feedback-id:feedback-id:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:subject:subject:to :to:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm1; t= 1740573271; x=1740659671; bh=mkfIwgWKTSQ8W177sqVs2/IANY7WvUftCyC sjig8L0k=; b=JUfnSHRjD5YZfabfiWCVcv5qLgAJMsGF+hEolbXSyaGEpmO5NVY zkPNaQvjgHJ3n4ffwqzP3DuOHHcr7H2byK80eYdQQQAeWehKZ03XOvFnUaVk5uBW lulOZQpsW1Vsy5Q7g1oZgrnsaAbdZBhwmYbtbue5V94hjAzo6XaE2yWAhNTmf74W dHOBdGZv4mpoQtu7Icb5MV2SoZHLXQgTAWjZFthqXTtFRzCV61/HhaKlOzAMpek3 fcKJVtOlC9pd7w4hKXQOzZFf//L7jnGjxHiXN+eeH9CMK8SNnNjwCOrsHESWsL1C 0pgcD26/APbYE0lmaAImgpVrGPddv/eLkHg== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefvddrtddtgdekgeehlecutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpggftfghnshhusghstghrihgsvgdp uffrtefokffrpgfnqfghnecuuegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivg hnthhsucdlqddutddtmdenucfjughrpefhvfevufhfffgjkfgfgggtsehttdertddtreej necuhfhrohhmpeffrghgfhhinhhnucfklhhmrghrihcuofgrnhhnshonkhgvrhcuoehilh hmrghrihesihhlmhgrrhhirdhorhhgqeenucggtffrrghtthgvrhhnpeekleejueefhfff kefhkedtfeeluedvieeihfehfeeffeeggeduffduheejjeeigfenucevlhhushhtvghruf hiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpehilhhmrghrihesihhlmhgrrhhi rdhorhhgpdhnsggprhgtphhtthhopedugedpmhhouggvpehsmhhtphhouhhtpdhrtghpth htohepuggvrghnrdgrrdhrrghshhgvvggusehgmhgrihhlrdgtohhmpdhrtghpthhtohep vgifihgvsegvfihivgdrnhgrmhgvpdhrtghpthhtohepphdrlhhuiigrnhhovhesphhosh htghhrvghsphhrohdrrhhupdhrtghpthhtohepphgvthgvrhesvghishgvnhhtrhgruhht rdhorhhgpdhrtghpthhtohepshhimhhsvghihhesrghmrgiiohhnrdgtohhmpdhrtghpth htohepnhgrthhhrghnuggsohhsshgrrhhtsehgmhgrihhlrdgtohhmpdhrtghpthhtohep jhhimhdrjhhonhgvshesuhhnihdqmhhuvghnshhtvghrrdguvgdprhgtphhtthhopegurg hvihgurdhgrdhjohhhnhhsthhonhesghhmrghilhdrtghomhdprhgtphhtthhopehpghhs qhhlqdhhrggtkhgvrhhssehpohhsthhgrhgvshhqlhdrohhrgh X-ME-Proxy: Feedback-ID: i1ff147bf:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Wed, 26 Feb 2025 07:34:29 -0500 (EST) From: =?utf-8?Q?Dagfinn_Ilmari_Manns=C3=A5ker?= To: Alvaro Herrera Cc: Sami Imseih , Tom Lane , Maiquel Grassi , Hunaid Sohail , "pgsql-hackers@postgresql.org" , "David G. Johnston" , Jim Jones , Nathan Bossart , "Imseih (AWS), Sami" , Peter Eisentraut , Pavel Luzanov , Erik Wienhold , Dean Rasheed Subject: Re: Psql meta-command conninfo+ References: <202502252118.5zgn3hmm37gf@alvherre.pgsql> Date: Wed, 26 Feb 2025 12:34:28 +0000 In-Reply-To: <202502252118.5zgn3hmm37gf@alvherre.pgsql> (Alvaro Herrera's message of "Tue, 25 Feb 2025 22:18:47 +0100") Message-ID: <87mse828bv.fsf@wibble.ilmari.org> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/27.1 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Alvaro Herrera writes: > On 2025-Feb-22, Alvaro Herrera wrote: > >> Also, there's a bunch of "(char *)" casts that are 100% due to >> printTableAddCell() taking a char * instead of const char * for the cell >> value. That seems a bit silly, we should change that. > > Ah, but the problem is that most of the input cells there come from > PQgetValue which returns a char *, so we'd need different casts > elsewhere. Nevermind this ... Also, it calls mbvalidate(cell, ...), which can modify the contents (stripping out invalid characters), so we'd better hope all the possible PQsslAttribute() values are valid UTF-8 or we've got possible UB on our hands. - ilmari