[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    [postgis-users] Fwd: constraint violation : enforce_geotype_the_geom
From:       Guillaume LONGUETAUD <mister.tefal () gmail ! com>
Date:       2010-07-27 12:15:10
Message-ID: AANLkTikzjAZDO=w0mjiEb=HbSiWCDM-xj+FCPZFggLHe () mail ! gmail ! com
[Download RAW message or body]

[Attachment #2 (multipart/alternative)]


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

[Attachment #5 (text/html)]

<div class="gmail_quote"><br>Hello, there<br clear="all"><br>I&#39;m quite new to \
postgis requests and I&#39;ve got a constraint violation problem with one of my \
requests:<br><br>

<p style="margin: 0px; text-indent: 0px;">create table bati_buff (id serial primary \
key);</p> <p style="margin: 0px; text-indent: 0px;">select addgeometrycolumn \
(&#39;bati_buff&#39;, &#39;the_geom&#39;, 27572, &#39;POLYGON&#39;, 2 ) ;</p> <p \
style="margin: 0px; text-indent: 0px;">insert into bati_buff (the_geom)</p> <p \
style="margin: 0px; text-indent: 0px;">(select bati.the_geom from bati, buffer where \
intersects (bati.the_geom, buffer.the_geom) =true ) ;</p><br><br>I have a constraint \
violation with the relation enforce_geotype_the_geom.<br>

<br>How can I solve it ?<br><br>Thanks<br>-- <br><font color="#888888">Guillaume \
Longuetaud<br> </font></div>



_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users


[prev in list] [next in list] [prev in thread] [next in thread]