Hi,
I found in forum of postgresql your discussion.
In fact, I've the same problem, when I 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.
Monia REZGUI