Re: POC PATCH: copy from ... exceptions to: (was Re: VLDB Features)

From: torikoshia <torikoshia(at)oss(dot)nttdata(dot)com>
To: Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>
Cc: Damir Belyalov <dam(dot)bel07(at)gmail(dot)com>, andres(at)anarazel(dot)de, tgl(at)sss(dot)pgh(dot)pa(dot)us, daniel(at)yesql(dot)se, anisimow(dot)d(at)gmail(dot)com, HukuToc(at)gmail(dot)com, Andrey Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru>, Alena Rybakina <lena(dot)ribackina(at)yandex(dot)ru>
Subject: Re: POC PATCH: copy from ... exceptions to: (was Re: VLDB Features)
Date: 2023-08-21 12:04:31
Message-ID: c0fb57b82b150953f26a5c7e340412e8@oss.nttdata.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Since v5 patch failed applying anymore, updated the patch.

On 2023-03-23 02:50, Andres Freund wrote:
> I suggest adding a few more tests:
>
> - COPY with a datatype error that can't be handled as a soft error

I didn't know proper way to test this, but I've found data type widget's
input function widget_in() defined to occur hard-error in regress.c,
attached patch added a test using it.

--
Atsushi Torikoshi
NTT DATA CORPORATION

Attachment Content-Type Size
v6-0001-Add-new-COPY-option-IGNORE_DATATYPE_ERRORS.patch text/x-diff 12.4 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Ashutosh Bapat 2023-08-21 12:23:01 Re: Oversight in reparameterize_path_by_child leading to executor crash
Previous Message Etsuro Fujita 2023-08-21 11:27:45 Re: postgres_fdw: wrong results with self join + enable_nestloop off