[gdal-dev] COPY statement failed with PG_USE_COPY=YES

[Matteo Ghetta]

Hi all,

I'm trying to import (many) shapefiles into a PG database. I'm facing 
the following error, but only when PG_USE_COPY is set to YES:

ERROR 1: COPY statement failed.
ERROR:  date/time field value out of range: "0000/00/00"
CONTEXT:  COPY TABLE, line 12682, column DATA_INI: "0000/00/00"

The value in the source shapefile is NULL for some rows. With 
PG_USE_COPY NO the import works perfectly.

I've found this old ticket, that seems to describe this exact issue, and 
is marked as resolved:

https://trac.osgeo.org/gdal/ticket/4265

Tested with:

* GDAL 3.2.2, released 2021/03/05
* GDAL 3.7.3, released 2023/10/30

Do you have any ideas about what is causing this?

Cheers and thanks

Matteo