Re: New "raw" COPY format

From: "Joel Jacobson" <joel(at)compiler(dot)org>
To: "Tatsuo Ishii" <ishii(at)postgresql(dot)org>
Cc: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: New "raw" COPY format
Date: 2024-10-15 12:49:25
Message-ID: d6ec4067-c40b-4967-8711-b1f991aacba3@app.fastmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Oct 15, 2024, at 09:54, Joel Jacobson wrote:
> On Tue, Oct 15, 2024, at 03:35, Joel Jacobson wrote:
>> On Mon, Oct 14, 2024, at 21:59, Joel Jacobson wrote:
>>> On Mon, Oct 14, 2024, at 10:51, Joel Jacobson wrote:
>>>> On Mon, Oct 14, 2024, at 10:07, Joel Jacobson wrote:
>>>>> Attached is a first draft implementation of the new proposed COPY "raw" format.
>>>>>
>>>>> The first two patches are just the bug fix in HEAD, reported separately:
>>>>> https://commitfest.postgresql.org/50/5297/
...
> Btw, anyone know if it's possible to download the "regression.diffs"
> file from a the Ci task?

Thanks @Matthias for the help,
found it at https://api.cirrus-ci.com/v1/artifact/task/5938219148115968/testrun/build/testrun/regress/regress/regression.diffs

The Windows problem was due to a test that inserted a "\n" as a text column,
to test that it should be parsed as an extra newline.
I've removed that part now from the test, since it's covered by the other tests,
with the hard-coded files.

/Joel

Attachment Content-Type Size
v9-0001-Fix-thinko-in-tests-for-COPY-options-force_not_null-.patch application/octet-stream 4.6 KB
v9-0002-Fix-validation-of-FORCE_NOT_NULL-FORCE_NULL-for-all-.patch application/octet-stream 5.0 KB
v9-0003-Replace-binary-flags-binary-and-csv_mode-with-format.patch application/octet-stream 18.6 KB
v9-0004-Set-default-format-if-not-specified.patch application/octet-stream 929 bytes
v9-0005-Separate-DELIMITER-and-NULL-option-validation-into-t.patch application/octet-stream 9.2 KB
v9-0006-Separate-QUOTE-option-validation-into-its-own-sectio.patch application/octet-stream 2.4 KB
v9-0007-Separate-ESCAPE-option-validation-into-its-own-secti.patch application/octet-stream 2.5 KB
v9-0008-Separate-DEFAULT-option-validation-into-its-own-sect.patch application/octet-stream 5.0 KB
v9-0009-Separate-HEADER-option-validation-into-its-own-secti.patch application/octet-stream 1.5 KB
v9-0010-Separate-FORCE_QUOTE-option-validation-into-its-own-.patch application/octet-stream 2.2 KB
v9-0011-Separate-FORCE_NOT_NULL-option-validation-into-its-o.patch application/octet-stream 2.2 KB
v9-0012-Separate-FORCE_NULL-option-validation-into-its-own-s.patch application/octet-stream 2.2 KB
v9-0013-Separate-FREEZE-option-validation-into-its-own-secti.patch application/octet-stream 1.6 KB
v9-0014-Separate-ON_ERROR-option-validation-into-its-own-sec.patch application/octet-stream 1.4 KB
v9-0015-Separate-REJECT_LIMIT-option-validation-into-its-own.patch application/octet-stream 2.0 KB
v9-0016-Add-raw-COPY-format-support-for-unstructured-text-da.patch application/octet-stream 43.7 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Artur Zakirov 2024-10-15 13:16:07 Re: type cache cleanup improvements
Previous Message Gurev Oleg 2024-10-15 12:44:40 Added anchor links generation function for refsect1,2,3