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 1u4MOn-0017HF-Gu for pgsql-hackers@arkaria.postgresql.org; Mon, 14 Apr 2025 16:11:06 +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 1u4MOl-002o4m-Ba for pgsql-hackers@arkaria.postgresql.org; Mon, 14 Apr 2025 16:11:04 +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 1u4MNR-002hsK-45 for pgsql-hackers@lists.postgresql.org; Mon, 14 Apr 2025 16:09:42 +0000 Received: from flow-b2-smtp.messagingengine.com ([202.12.124.137]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1u4MNP-0002rl-00 for pgsql-hackers@lists.postgresql.org; Mon, 14 Apr 2025 16:09:41 +0000 Received: from phl-compute-03.internal (phl-compute-03.phl.internal [10.202.2.43]) by mailflow.stl.internal (Postfix) with ESMTP id D60111D40275; Mon, 14 Apr 2025 12:09:37 -0400 (EDT) Received: from phl-mailfrontend-02 ([10.202.2.163]) by phl-compute-03.internal (MEProxy); Mon, 14 Apr 2025 12:09:37 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=kurilemu.de; h= cc:cc:content-transfer-encoding:content-type:content-type:date :date:from:from:in-reply-to:in-reply-to:message-id:mime-version :reply-to:subject:subject:to:to; s=fm1; t=1744646977; x= 1744654177; bh=gq9EneCLdVGaqlaTP5PdaCOl4nzQoIKBcsMURSNkEfY=; b=i t+lWIz0BLalVxGaV0RXSWM72Vdt5mMaRDkaDkKWsihxV7u6nMuE/DniW1bJ5MVuW yjG1mksxNqo3f5jOUvOhroCc6Gdc418g5CaBnr7aEPF/jLdZhlxbXUOG3v3zT2YA bbENRjWtGo73maxTtmzdHDInxm6Vp9JhxCDZA/5vR3DYhmT1P2FC897bTD5iHdy0 iyuBGjg2q5AsLMUkVuNpjCv+Ct1/wBYQqra+pY0SjaABOmE/hM1EtBz8/AOQktUR YJbEu7uq8KlYB4zTxpjI+2lqM91VVKcNMF5FC96t3nEECR02q0/+UCO/DGx9cATl 6wuAAd/JXnEeAsJTfQv2Q== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:content-type:date:date:feedback-id:feedback-id :from:from:in-reply-to:in-reply-to:message-id:mime-version :reply-to:subject:subject:to:to:x-me-proxy:x-me-sender :x-me-sender:x-sasl-enc; s=fm2; t=1744646977; x=1744654177; bh=g q9EneCLdVGaqlaTP5PdaCOl4nzQoIKBcsMURSNkEfY=; b=laal//iCfgGG75XK9 kb+D64AbA6jviV5eHhDOGdBUcZZp+W+qPt9x5aW/6FC/KJdikXQVdj5fj01BF4/N eL+qftkWm/4migReHuMB9MuLvbJVdBwKICuNf6yRb7nkpHVQLOi6Qa8hDdZ6cGWW mOD8jdWelTMiBCZHcG0pdu6/SMOml409SWGPy76RlkYMJa0Y1Md19ph91yVzXfRD tgtMeQdniHljeZaVW8+h8Q3MkDk+poNJHwFpxK1Ho8TdX9Q+/gu/PGrcn33ameJ+ cWlhmoMD6ZJD5Yd+yVKGbsLfmQfHqKYTL0JJlg4u1XEn+36D35Q05qDBajeI5Ygm SdWpQ== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefvddrtddtgddvvddtleelucetufdoteggodetrf dotffvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdggtfgfnhhsuhgsshgtrhhisggv pdfurfetoffkrfgpnffqhgenuceurghilhhouhhtmecufedttdenucesvcftvggtihhpih gvnhhtshculddquddttddmnecujfgurhepfffhvfevuffkgggtugfgjgesmhekreertddt jeenucfhrhhomheplmhlvhgrrhhoucfjvghrrhgvrhgruceorghlvhhhvghrrhgvsehkuh hrihhlvghmuhdruggvqeenucggtffrrghtthgvrhhnpeegudetudejheduveevgeehjeeg leevveevvdeutdejtdekuefhheehgeevtdejteenucffohhmrghinhepvghnthgvrhhprh hishgvuggsrdgtohhmnecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghi lhhfrhhomheprghlvhhhvghrrhgvsehkuhhrihhlvghmuhdruggvpdhnsggprhgtphhtth hopeefpdhmohguvgepshhmthhpohhuthdprhgtphhtthhopegrnhgurhgvfiesughunhhs lhgrnhgvrdhnvghtpdhrtghpthhtohepmhgrhhhiiehruhhnsehgmhgrihhlrdgtohhmpd hrtghpthhtohepphhgshhqlhdqhhgrtghkvghrsheslhhishhtshdrphhoshhtghhrvghs qhhlrdhorhhg X-ME-Proxy: Feedback-ID: ie3de48e3:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Mon, 14 Apr 2025 12:09:30 -0400 (EDT) Received: by schmee.alvh.no-ip.org (Postfix, from userid 1000) id 6C1608E; Mon, 14 Apr 2025 14:20:10 +0200 (CEST) Date: Mon, 14 Apr 2025 14:20:10 +0200 From: =?utf-8?Q?=C3=81lvaro?= Herrera To: Andrew Dunstan , Mahendra Singh Thalor Cc: pgsql-hackers@lists.postgresql.org Subject: Re: pgsql: Non text modes for pg_dumpall, correspondingly change pg_restore Message-ID: <202504141220.343fmoxfsbj4@alvherre.pgsql> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="2h4sxwwjii2o4jzh" 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 --2h4sxwwjii2o4jzh Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit On 2025-Apr-04, Andrew Dunstan wrote: > Non text modes for pg_dumpall, correspondingly change pg_restore I think the new oid_string_list stuff in this commit is unnecessary, and we can remove a bunch of lines by simplifying that to using SimplePtrList, as the attached illustrates. (Perhaps the names of members of the proposed struct can be improved.) I also propose to remove the open-coded implementation of pg_get_line. WDYT? I'm also not sure about the double sscanf() business there ... There must be a better way to do this. -- Álvaro Herrera Breisgau, Deutschland — https://www.EnterpriseDB.com/ --2h4sxwwjii2o4jzh Content-Type: text/x-diff; charset=utf-8 Content-Disposition: attachment; filename="0001-remove-unnecessary-oid_string-list-stuff.patch"