[postgis-users] Fwd: constraint violation : enforce_geotype_the_geom

[Agustin Ignacio Genoves]

You must check if the geometry is not null and the type is POLYGON

2010/7/27 Guillaume LONGUETAUD <mister.tefal at gmail.com>:
>
> 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
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>