Postgres Pro
Downloads
Home   >   mailing lists

Thread: help

help

From
rezgui monia
Date:
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

Re: help

From
"Jean-Yves F. Barbier"
Date:
On Tue, 19 Oct 2010 02:10:46 -0700 (PDT), rezgui monia
<rezgui.monia@yahoo.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.

--

Re: help

From
Kasia Tuszynska
Date:
Rezgui,
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...
Good luck,
Kasia


-----Original Message-----
From: pgsql-novice-owner@postgresql.org [mailto:pgsql-novice-owner@postgresql.org] On Behalf Of Jean-Yves F. Barbier
Sent: Tuesday, October 19, 2010 5:15 AM
To: pgsql-novice@postgresql.org
Subject: Re: [NOVICE] help

On Tue, 19 Oct 2010 02:10:46 -0700 (PDT), rezgui monia
<rezgui.monia@yahoo.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.

-- 

-- 
Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice