You must check if the geometry is not null and the type is POLYGON
2010/7/27 Guillaume LONGUETAUD <[email protected]>: > > Hello, there > > I'm quite new to postgis requests and I've got a constraint violation > problem with one of my requests: > > create table bati_buff (id serial primary key); > > select addgeometrycolumn ('bati_buff', 'the_geom', 27572, 'POLYGON', 2 ) ; > > insert into bati_buff (the_geom) > > (select bati.the_geom from bati, buffer where intersects (bati.the_geom, > buffer.the_geom) =true ) ; > > I have a constraint violation with the relation enforce_geotype_the_geom. > > How can I solve it ? > > Thanks > -- > Guillaume Longuetaud > > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > > _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
