This is a postgis question, I would suggest the postgis forums.
Right off the bat the the sql does not seem to be problematic, as it is an example from the postgis help.
I would venture a guess that you have not granted privs on the public.geometry_columns table...
From: pgsql-novice-owner(at)postgresql(dot)org [mailto:pgsql-novice-owner(at)postgresql(dot)org] On Behalf Of Jean-Yves F. Barbier
Sent: Tuesday, October 19, 2010 5:15 AM
Subject: Re: [NOVICE] help
On Tue, 19 Oct 2010 02:10:46 -0700 (PDT), rezgui monia
> 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
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.
Sent via pgsql-novice mailing list (pgsql-novice(at)postgresql(dot)org)
To make changes to your subscription:
In response to
- Re: help at 2010-10-19 12:14:53 from Jean-Yves F. Barbier
pgsql-novice by date
|Next:||From: Donald Kerr||Date: 2010-10-20 17:08:30|
|Subject: Re: Hex to Dec Conversion|
|Previous:||From: Bob McConnell||Date: 2010-10-19 12:42:19|
|Subject: Re: Overriding local encoding defaults|