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.96) (envelope-from ) id 1vllTP-003gPD-0T for pgsql-hackers@arkaria.postgresql.org; Fri, 30 Jan 2026 10:11:31 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vllTM-004H06-0W for pgsql-hackers@arkaria.postgresql.org; Fri, 30 Jan 2026 10:11:28 +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.96) (envelope-from ) id 1vllTL-004Gzx-2Y for pgsql-hackers@lists.postgresql.org; Fri, 30 Jan 2026 10:11:28 +0000 Received: from mail-ua1-x936.google.com ([2607:f8b0:4864:20::936]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1vllTK-00000000B2e-0wQq for pgsql-hackers@lists.postgresql.org; Fri, 30 Jan 2026 10:11:28 +0000 Received: by mail-ua1-x936.google.com with SMTP id a1e0cc1a2514c-9483a2eaddcso615981241.3 for ; Fri, 30 Jan 2026 02:11:25 -0800 (PST) ARC-Seal: i=1; a=rsa-sha256; t=1769767884; cv=none; d=google.com; s=arc-20240605; b=jjNqHOfOQ8WA374zCUmwuepHvLEYygv4D59ABCpQcbOl/vWeSs8If/StKpJGuKAODC uaq/A8pjoyuI4MBchYKGm2jpkMsrs14e9YxJNotqCacGKxtuAw+TuCXG914nzDEfixEl WxpuUMWOANF+fU6+kVgvMWVcg1PSEhXzNq6ikAJfSJMYPVVS8kLWcyocrTqvCbK6eVC/ MAKOBf3biWQpSiKhouY64mvWvW2p/t99fAe6BbPwRGp3kCiBBnXGqY6RHxCsb0VBIRLz WEwYLlDQpRhMmBltzQ2Q8bjmn+U+WUagu+zloGsm96YlnD6WFF0CO3atfiGU+LUsh3Ii Pacw== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:dkim-signature; bh=doe/+Ae+x3LHkioBgpcq/ANjhYqqKr8m7HI6luY3mFQ=; fh=/Tg0Um48AA1EvJJvsmcecsHUXcTfKL9HTfJ9sQV8QoY=; b=UQYXybUUWwkfQFl0fblzgnCOYhro6fN9fcI9YhSa6smVdkQJ87XsoWvUA3/fGijw60 Gs8TqRG/pHGkEiokkfJxa//W76K4ZBOC8iH2j6W6HnXRCBqahpv3gQJ2vx0rHy4gmOCi Mi4vDvRX0s2SFSPkl7JZiCbrbPmPjlR5amRcyiXpBwleEseNTEnvPtPF3fYZTWhNGe/3 VKMBaLozeqvljf7r2FuCNQWnk641oZJIpcvdZJKCedHCvUMAqXv35TC/OUFFyb/XcEB3 NdIZbNQUXSHGw5H8rWSR4jUXkAiNbqvJR+3bEj9H24aiwM3Jk67losPVJ0J6b8CEPGkq RdNw==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1769767884; x=1770372684; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=doe/+Ae+x3LHkioBgpcq/ANjhYqqKr8m7HI6luY3mFQ=; b=eflZPU6udVxXQ+sU+CSaBtgSNvexXUsbKQg3/2chwAabNE5PZj9Gh1AM9A4CrXMPp9 ZBwKU6eo3PDQL5F38HbU2usr8b0SWE0STMw398svHWytu50RCTEnUc1rPP7UcDimtajP 7G1WCtUVeJXrDPesQ6dYxrDKI/BmcXXqdTkr74xXTfPrnhnURra1P3L6GHBubBWpuDHT MKLXtMs0CeS/dskzuGS7hHd0oFytZqVWvlkp4bP1nScdv5qRAqJM6EQgjvmEJniNBnEC vXTElBR8zvc+uz/0ncmuTm2c7WE4GpIutMe+vT/WnU/zUhO9S0pGoOWF3Lgb9txkUr1q FV+g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1769767884; x=1770372684; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=doe/+Ae+x3LHkioBgpcq/ANjhYqqKr8m7HI6luY3mFQ=; b=LDSSIQgj2V8RZMzgzQp0arqCzQsJdD38HFFr3TgmVfTiOq1Gi/dhlInj2TlGY5Ep7E 3lby6wn9c07am4yQdfvwym6ELsFTd3/nq5smXkh4N0YSL8n0m9w1a2aw4HLi4xNPLx5d F0N+YYFuSnIcy9LnvoHAc459NOBYvJrocdu6dcDGPY8gPxwJDJsNC4OQ2VQL8dGt7cDm UL2cAMkzwO3MC3R0hKSfgBA+k4znOAx80uzKKQSZMeT4kL0jSqAsu8yhx51/1m/9yDiL nOUOKdJkSdbuxlLIZS/c0oW94E5ILVXeU5Mwb+OL6hiSUpRL++0Ai6B3WK07CJSmGgll eUBA== X-Forwarded-Encrypted: i=1; AJvYcCWs3Ew38/CbVYG+oXCJGnvWCoTvWaqP31hTkjhmBRPPrk1MTWdcRkBjcAmRiCldDPVFu2sMjXGdimMnt0D8@lists.postgresql.org X-Gm-Message-State: AOJu0Yy8fzzKDR3bWiGbkvKyXhM6CbyTSHHN5yTTgk6wJUuTrGCVTJ+n 5nUxGXcvWj9k3K7kIkI20uAOijahl0kCXiiImiCnC4Ss0h1Wes17fInI8CQbDr20y8QglyLz5lI BL7uRgp3Kb7NbGkEHNyHk9SczmQTVX8Q= X-Gm-Gg: AZuq6aJ4JiU5DYwYIuOmaffwzKxaeFueczFZ4Pu5ZE4fDgx6XToj4VDmWfhSUfQfnV6 aLg5vjpAD7j0xkKLBodHmkMhgcyWnhbZFkgN2nKIopedcxXcqHn2W8hsfsqbmSWdtMzNuDtu33w O5KqOYPHuhxH8HQKrQgvA2Xj13HpCN/i1ugg76qmxURlP+uCfTiwoqMgNAM55woujhjUWeOlKY+ 8iSIHhEortkPJdKO+QgOEh050P4mPt/EjZ2enOP5j1BAUhGEXwn9xL0ckj+NwQwdWsDokKy3oqd 6TLCaxTyk1whT4wf5ZiXfb7BS6KjaXhZ6I53rQl1354pfpScS7vhJ1JzKIvldANdDThRBfbXdMm /mvOp9ff9WGw9SozxKiu00ejovHJoVTNpliYKWxYESqRfQDheGDssidqJhOGZjnPZnUOy9AQWWJ sazTs3Os2k1w== X-Received: by 2002:a05:6102:818a:20b0:5f8:e2cb:d245 with SMTP id ada2fe7eead31-5f8e2cbd593mr433795137.0.1769767884224; Fri, 30 Jan 2026 02:11:24 -0800 (PST) MIME-Version: 1.0 References: <3279216.1767072538@sss.pgh.pa.us> <3730915.1767135010@sss.pgh.pa.us> <3924010.1767200681@sss.pgh.pa.us> <1706007.1768933913@sss.pgh.pa.us> <2402302.1769026170@sss.pgh.pa.us> In-Reply-To: <2402302.1769026170@sss.pgh.pa.us> From: jian he Date: Fri, 30 Jan 2026 18:10:47 +0800 X-Gm-Features: AZwV_QiyZza4XgY90BQV8-xMkGE9N5t2bFMfJMuSDzy1Obd7f3NY-ulyPmq_AVY Message-ID: Subject: Re: Can we remove support for standard_conforming_strings = off yet? To: Tom Lane Cc: Julien Rouhaud , John Naylor , Andrew Dunstan , pgsql-hackers@lists.postgresql.org Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk hi. _allocAH is called by OpenArchive and CreateArchive. in _allocAH, we can set AH->public.std_strings = true; that would be more future-proof, otherwise after OpenArchive, executing the query ``SET standard_conforming_strings = off;`` would result in an error. -- jian https://www.enterprisedb.com/