Re: New "raw" COPY format

From: "Joel Jacobson" <joel(at)compiler(dot)org>
To: "jian he" <jian(dot)universality(at)gmail(dot)com>
Cc: "Masahiko Sawada" <sawada(dot)mshk(at)gmail(dot)com>, "Tatsuo Ishii" <ishii(at)postgresql(dot)org>, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: New "raw" COPY format
Date: 2024-10-28 08:30:15
Message-ID: 5ac3b397-be78-463c-942f-c9b086cbd02e@app.fastmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Oct 28, 2024, at 08:56, jian he wrote:
> /* Check force_quote */
> - if (!opts_out->csv_mode && (opts_out->force_quote ||
> opts_out->force_quote_all))
> + if (opts_out->format != COPY_FORMAT_CSV && (opts_out->force_quote ||
> + opts_out->force_quote_all))
> ereport(ERROR,
> (errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
> /*- translator: %s is the name of a COPY option, e.g. ON_ERROR */
>
> maybe this has a code indentation issue.
> since "if" and "opts_out" in the same column position.

Thanks for review.

I've fixed the indentation issues.

> It came to my mind,
> change errmsg occurrence of "BINARY mode", "CSV mode" to "binary
> format", "csv format" respectively.
> I think "format" would be more accurate.
> but the message seems invasive,
> so i guess we need to use "mode".

That would work, I'm fine with either.

> overall v13-0001-Introduce-CopyFormat-and-replace-csv_mode-and-binary.patch
> looks good to me.

Cool.

/Joel

Attachment Content-Type Size
v14-0001-Introduce-CopyFormat-and-replace-csv_mode-and-binary.patch application/octet-stream 18.6 KB
v14-0002-Add-raw-format-to-COPY-command.patch application/octet-stream 43.7 KB
v14-0003-Reorganize-option-validations.patch application/octet-stream 19.8 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jingtang Zhang 2024-10-28 08:43:09 Re: Introduce new multi insert Table AM and improve performance of various SQL commands with it for Heap AM
Previous Message 黄铎彦 2024-10-28 08:14:23 Re: msvc directory missing in PostgreSQL 17.0