[Gdal-dev] ogr2ogr shapefile to postgis error

Michael Mallete mrmallete at gmail.com
Wed Sep 29 22:30:07 EDT 2004

good day sir! thank you very much for your kind reply. :)

yes it's a new table being created by ogr2ogr. how do i set the
CPL_DEBUG environment variable?

anyways, i am using the OpenEV_FW kit in a Win2k platform. i am using
ogr2ogr to convert and insert shapefiles to postgis to an external
server running on a win2k server platfrom. i've had success converting
and inserting my other shapefiles. i only encounter this problem from
time to time. i'm wondering what's so unique with the data which
failed with the data which were successfully converted/inserted.

anyways, thanx again sir! hoping my problem is solvable. 

have a nice day! :)


On Wed, 29 Sep 2004 09:14:27 -0400, Frank Warmerdam <warmerdam at pobox.com> wrote:
> Michael Mallete wrote:
> > good day everyone!
> >
> > i am encountering some problems converting shapefiles to postgis using
> > ogr2ogr. upon execution, i get this error:
> >
> > ERROR 1: INSERT command for new feature failed.
> > ERROR: new row for relation "<table name here>" violates check
> > constraint "enforce_geotype_wkb_geometry"
> >
> > ERROR 1: Terminating translation prematurely after failed translation
> > of layer <table name here>
> >
> > hope you could help. thanx in advance. have a nice day everyone! :)
> Myk,
> Is this a new table being created by ogr2ogr?  I have never encountered
> this error before.
> You might want to set the CPL_DEBUG environment variable to a value of ON
> and then rerun.  You will get quite a bit more information about what is
> going on internally then.
> Best regards,
> --
> ---------------------------------------+--------------------------------------
> I set the clouds in motion - turn up   | Frank Warmerdam, warmerdam at pobox.com
> light and sound - activate the windows | http://pobox.com/~warmerdam
> and watch the world go round - Rush    | Geospatial Programmer for Rent

More information about the Gdal-dev mailing list