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 1w2aQH-000QAP-0A for pgsql-hackers@arkaria.postgresql.org; Tue, 17 Mar 2026 19:49:49 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w2aQF-004XFR-2o for pgsql-hackers@arkaria.postgresql.org; Tue, 17 Mar 2026 19:49:47 +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.96) (envelope-from ) id 1w2aQF-004XFJ-1t for pgsql-hackers@lists.postgresql.org; Tue, 17 Mar 2026 19:49:47 +0000 Received: from mail-qv1-xf2c.google.com ([2607:f8b0:4864:20::f2c]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w2aQC-00000000F1H-1KUz for pgsql-hackers@postgresql.org; Tue, 17 Mar 2026 19:49:46 +0000 Received: by mail-qv1-xf2c.google.com with SMTP id 6a1803df08f44-89c52ef3c2fso22226966d6.0 for ; Tue, 17 Mar 2026 12:49:44 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=dunslane-net.20230601.gappssmtp.com; s=20230601; t=1773776984; x=1774381784; darn=postgresql.org; h=content-transfer-encoding:in-reply-to:autocrypt:content-language :from:references:cc:to:subject:user-agent:mime-version:date :message-id:from:to:cc:subject:date:message-id:reply-to; bh=fNZNI5enXd7qi/4GaDrVVaVz/8iBc+i/0j/gFwpcjkY=; b=TlsDfl10U1Fo8ftwaFl74ol995zwVXxKXgslQd2qo5D+iIs0TpJ7vV7hE2NxkNYObO sxud5Qe6iflus1po7QwaaeZ9WGfOWHWNhq8ZzfIZk+CajCy0O4lGuHxbOgUqr4rBS7Td zPmiWpHo+WGwrynOsq58PDV2/iNXO2hytwnxqCw4KDmDKlaLnge4DorZmLM62Q+Md16F saOP59tqRmU9EAYHxf3Ndt3U6Mmi2ulP2QToakLagTZx45xeT8N/X3gLAQFcR/k60Dzr ++NV9RwddaZBDOn/T5MbYk/ydHuGrAsfPfE9CcIn+MC+hlDoifkmYy4J3D/EVzPtFIlo oSrg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1773776984; x=1774381784; h=content-transfer-encoding:in-reply-to:autocrypt:content-language :from:references:cc:to:subject:user-agent:mime-version:date :message-id:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=fNZNI5enXd7qi/4GaDrVVaVz/8iBc+i/0j/gFwpcjkY=; b=aEa+DrO7trgAW9MSKYblHjczlJ5p8isP34H/zH3JF0MEHH/6VKDAbam1WyeQs5GhWG zIDhYZqQSlJ4jD/icJi+BY7Ip1sZY1LZ94VA6Cjb3O0UTH5/0+FRVi0aJy05Ndtiv3z7 0791K7xyC+i2LdHnEl6ACgd3zOQA9ERnTXLWP4N+Z+sPrBA7gd/0/ElE5sYpcdjR04aQ kavl31ome+pKdQZPY8xTk9MMd6bdkAkEWpPAG6GBOISF2lavlG33251ulrkQWFmouRAW kV5Y4w2lHB1i8GkcNfwsD66+fsOdqes8eVXXWL0Ai1c/cG8bJNE+hnkmvGBZQXDXps1c JGfg== X-Forwarded-Encrypted: i=1; AJvYcCWn3+k9ec9hz78Iexiz/sZFb0PKFzZH8DjX6ynghKRgQAymR/TUcULG795lg95aFC9zS5aaPaU07W4jLYO7@postgresql.org X-Gm-Message-State: AOJu0Yw16MnnZAxPMIFOjzzRQhuEb4fZyXmdHThSj4HF4cn0VAXamsDU g3IrykmFUWMQOwNg3NJXn65/KG0ku8oUnd0TXna8XFAb6YKUmDeg5I7Nhpje1j8yJL4= X-Gm-Gg: ATEYQzy1lAtVCljtDF/2uoNkhZGOQ77PnBSOH58zP2dHvhzsDosm73hNlu8dXHY3174 E0k0OnoqsMidMDAlJ49b+PXdtF8jp1I4xZlboP71bOUq9eBvZxh3lgxYX6rf6BWty4ymZatY4N1 Ee4q6ijYGOSHXEWUygA7ikXzmqWYM0l2K6/H2wqpzT6Qufc+TA7fJA797zXO+RBokNoVtzXWG8r Mo4ry5sVsmntcPqQEwNQF3lBKV2fZSTEO97frUGSgK1OKs/SdCeOk3Vmaxo+6Tp/ohjyYf1jE+P bYS6latgqy0FiBa0iPieIbCUnzqs0Ph9ZtY4ni0W2BieEBO+0iQ59PEGRRAICViCOxjmaJ0Gn6r ziT4n4LQJwAo+u2Eqy1Mt0MdkuR8uGnnA8zpXE+IxKO/43XGocU7Dg+Cv0QVI6sCp9rDtlJHLoX yZHeHgUWaOoCQALyZYGT06/rhfZsOQ0Q== X-Received: by 2002:a05:6214:4ecf:b0:89a:157a:39a6 with SMTP id 6a1803df08f44-89c6b5f8d3amr12014076d6.60.1773776984219; Tue, 17 Mar 2026 12:49:44 -0700 (PDT) Received: from ?IPV6:2605:a601:a6b0:500::1cb? ([2605:a601:a6b0:500::1cb]) by smtp.googlemail.com with ESMTPSA id 6a1803df08f44-89c6b9ce2fdsm4411806d6.26.2026.03.17.12.49.41 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Tue, 17 Mar 2026 12:49:43 -0700 (PDT) Message-ID: <33f88bd8-fd85-4217-84a9-b5086a6094da@dunslane.net> Date: Tue, 17 Mar 2026 15:49:39 -0400 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Emitting JSON to file using COPY TO To: Masahiko Sawada Cc: jian he , Joe Conway , Junwang Zhao , Florents Tselai , "Andrey M. Borodin" , Dean Rasheed , Daniel Verite , Davin Shearer , PostgreSQL-development References: <74d3b4e2-d201-489d-9b9a-1a6d0eb492a6@dunslane.net> <6cbbf7f3-da4a-4201-98a6-4347a3c35db0@joeconway.com> <8154f8e2-7d9c-442f-a7cb-a5caf38f6a12@dunslane.net> <57db4b6e-51ba-4984-9343-bc62a3ee0b7c@dunslane.net> <964a3377-d957-4a06-ad02-8228aefa65fc@dunslane.net> From: Andrew Dunstan Content-Language: en-US Autocrypt: addr=andrew@dunslane.net; keydata= xsBNBE7KWFkBCAClridxur2AIc7eW2AR7izbfp3EnNefie2HbLF0izW5Ik5UjX2HBXBx4syI gY6b0ugohXrr274+baoAlvSbq6cAoQuEVrk5IZFzt20b1Xkx65FwGSEj526yiKLocqkJceSq Xr9xcA5SGY+FZv441chh5SU92v4q6z+6LPpoHOh97ptAVXZYNTtU0LevyvD5lja0TzbvJm6C eFXitJfnm1pLEr0DGJCR/iUOl/N62Kh4855zZC7NHIjQHPOvV5Stz/l5ilDhvGVk+xkXFPys SjZoUr1rXhYLpiyi5sR0X9FHXT0KnGuz1F5ERO7ZTLSSQ6fJwPj6gOk9K+vvoKvoeql5ABEB AAHNJEFuZHJldyBEdW5zdGFuIDxhbmRyZXdAZHVuc2xhbmUubmV0PsLAlwQTAQgAQQIbAwIX gAIZAQULCQgHAwUVCgkICwUWAgMBAAIeBRYhBOQ+WEYd/Hy/RGkVpZn6f8tZ/DuBBQJoGNGd BQkdEO8nAAoJEJn6f8tZ/DuBq74H/jkTR4Zi3stbw+xC7v2u3QozssK7MYPL2AsVfh7OealS h182fiWXpfvmmAB7WUHbhk9GC2RAOnHI/2d2jgKaMLAHsGYOT0YopTVIwRY43fCw/mK67yxc wmDcX+zyKfLaivNbf5A7QPLNwda98bEAMSJ8Sn652Uc6cA8t3uKGsVzbRBQOoYzjgvBCfSrE 9ql3PDNg0l4BfAqabd2f70ZUm9VAMEPrgv/v2xI7M2XiL4g5BVmqLCOwxLM8RMCotCuoweUr VO43DeBCIDwLxotMJKvGWDjBzQYlU1NPUAtNcz/gN9ITUe1VUGjyvGj4u1lxBOcQQUw7l1+T 5moZ4iZxXzvOwE0ETspYWQEIANGc4zQULOxhbqO2dyD51YhqCNRmm9oKWaqf+wmW4tpDe/VV cxAnNizd4LWCHfzpb5cHAtGkOPePMfzWVf6nvdF7d3eglbtf59+zG7O7llV0xSSoFiieQBsr GvqDInXYX/4mRRXMtyhM353/tixC9RWLs1oofyYmCPPXXY7h9R7en3B8BoVrRFcdzlIY/NFN hFGW/9dkEiGjgna2Rk6e15kln4ZvFBWUg23p93w/pqXcxY6+k/8TEk+C4R+M6w7o2PLGOjdZ +kPiUcw5H85zf/yZJwQXzisXaNduwWB6Vads9YC9dj6kPR1c4VGRqAaYL++LAEOqrlvm2Tvq QqZRtnEAEQEAAcLAfAQYAQgAJgIbDBYhBOQ+WEYd/Hy/RGkVpZn6f8tZ/DuBBQJoGNI2BQkd EODdAAoJEJn6f8tZ/DuBfw0IAKTsfD40teP/pp+bsLLMSxPXUYrrprTj7WFB5v61p6dkpSr/ qXmMlyahdxQFaPmfVgVirB1Vk/kHiWNnnGjfUV9nB2Zg9LI0Xb9/ts3LsUiRWXzG3tkMY6XL vsVOxW4XFRND9l2q+WW93aZ1DZl+fqWfYgMvsusFRhmGFOKTRfKPta2Pkv+AhA24N4+PrR5p bU4k2MO8PAGiK8eaYKGFG1bHKuAvoDoF7WXJ3FHxuWqLnKEt4dfOLm5pAe3zq1Lt6q8azT9i QWGpSAK5vQUWQHBHpiDjdPeqKZ6HiAXIIKfSmb+jrvXBqoP+D6/K7rUjG2aXiRtTIAXms9sm VRu7cmw= In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2026-03-17 Tu 1:50 PM, Masahiko Sawada wrote: >> >> Here's a v30 set that I hope fixes these issues. > Thank you for updating the patch! The patches look good to me. > Thanks. Planning to push this tomorrow. cheers andrew -- Andrew Dunstan EDB: https://www.enterprisedb.com