On vendredi 8 janvier 2021 15:58:39 CET matteo wrote: > Hi all, > > I've 2 small questions during a syncing from a GPKG to a PG DB with > constraints using -skipfailures: > > * is it possible to show only the constraint error and not also the > insert one? Even if there is only a single error, reading the log it > seems that there are 2 of them (I know a person should only read....) > * is there are 2 errors (e.g. constraints error) BUT in the same record, > ogr2ogr shows only the first one and not all of them
Why not experimenting outside GDAL a bit ? $ psql # create table foo(bar integer check (bar = 1), baz integer check (baz = 1)); # insert into foo values (2,2); ERROR: new row for relation "foo" violates check constraint "foo_bar_check" DETAIL: Failing row contains (2, 2). and asking your favorite search engine about "postgresql get all constraint violations" ==> https://stackoverflow.com/questions/23822162/error-message-with-all-constraint-violations-in-postgres Even -- Spatialys - Geospatial professional services http://www.spatialys.com _______________________________________________ gdal-dev mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/gdal-dev
