On Tue, 19 Oct 2010 02:10:46 -0700 (PDT), rezgui monia
<rezgui(dot)monia(at)yahoo(dot)com> wrote:
> INSERT INTO ROADS (ROAD_ID,ROADS_GEOM,ROAD_NAME ) VALUES
> (1,GeomFromText('LINESTRING(191232 243118,191108 243242)',-1),'Jeff Rd');
>
> it returns: "new row for relation 'roads' violate check constraints"
> Please, if you remember any things to resolve this problem, please help
> me.
May be not related, but try to never insert a primary key: as you insert
1 for road_id, the PK sequence is NOT incremented; use default instead.
--