Re: Allow COPY's 'text' format to output a header - Mailing list pgsql-hackers

From Simon Muller
Subject Re: Allow COPY's 'text' format to output a header
Date
Msg-id CAF1-J-2nSney4Uae2-ZSFirH-4tLKfd9=_TUNTjXzdLcN=CUvA@mail.gmail.com
Whole thread Raw
In response to Re: Allow COPY's 'text' format to output a header  (Michael Paquier <michael@paquier.xyz>)
Responses Re: Allow COPY's 'text' format to output a header
Re: Allow COPY's 'text' format to output a header
List pgsql-hackers
Okay, I've added this to the next commitfest at https://commitfest.postgresql.org/18/1629/.

Thanks both Michael and David for the feedback so far.


On 14 May 2018 at 02:37, Michael Paquier <michael@paquier.xyz> wrote:
On Sun, May 13, 2018 at 07:01:00PM -0400, David Steele wrote:
> This patch makes sense to me and looks reasonable.

One "potential" problem is if a relation has a full set of column which
allows the input of text-like data: if the header has been added with
COPY TO, and that the user forgets to add again the header option with
COPY FROM, then an extra row will be generated but there is the same
problem with CSV format :)

One comment I have about the patch is that there is no test for
COPY FROM with an output file which has a header.  In this case if
HEADER is true then the file can be loaded.  If HEADER is wrong, an
error should normally be raised because of the format (well, let's
discard the case of the relation with text-only columns).  So the tests
could be extended a bit even for CSV.

> We're in the middle of a feature freeze that will last most of the
> summer, so be sure to enter your patch into the next commitfest so it
> can be considered when the freeze is over.
>
> https://commitfest.postgresql.org/18/

Yes, you will need to be patient a couple of months here.
--
Michael

pgsql-hackers by date:

Previous
From: Ashutosh Bapat
Date:
Subject: Re: Expression errors with "FOR UPDATE" and postgres_fdw withpartition wise join enabled.
Next
From: Kyotaro HORIGUCHI
Date:
Subject: Re: [HACKERS] [BUGS] Bug in Physical Replication Slots (at least9.5)?