Re: Add support for DEFAULT specification in COPY FROM - Mailing list pgsql-hackers

From Israel Barth Rubio
Subject Re: Add support for DEFAULT specification in COPY FROM
Date
Msg-id CAO_rXXARfeAdjcqLMPo2+y38sS6HqVYqFaJCT5-bLvGRAv7qgg@mail.gmail.com
Whole thread Raw
In response to Re: Add support for DEFAULT specification in COPY FROM  (Andrew Dunstan <andrew@dunslane.net>)
Responses Re: Add support for DEFAULT specification in COPY FROM
Re: Add support for DEFAULT specification in COPY FROM
List pgsql-hackers
Hello Andrew,

> . There needs to be a check that this is being used with COPY FROM, and
> the restriction needs to be stated in the docs and tested for. c.f.
> FORCE NULL.

> . There needs to be support for this in psql's tab_complete.c, and
> appropriate tests added

> . There needs to be support for it in contrib/file_fdw/file_fdw.c, and a
> test added

> . The tests should include psql's \copy as well as sql COPY

> . I'm not sure we need a separate regression test file for this.
> Probably these tests can go at the end of src/test/regress/sql/copy2.sql.

Thanks for your review! I have applied the suggested changes, and I'm
submitting the new patch version.

Kind regards,
Israel.
Attachment

pgsql-hackers by date:

Previous
From: "Jonathan S. Katz"
Date:
Subject: PostgreSQL 15 GA release date
Next
From: James Coleman
Date:
Subject: Re: Consider parallel for lateral subqueries with limit