Hello!
> Happened when i tried to add some points to a layer (containing POIs)
> loaded from a postgis database. I fired up eclipse enabled trancing and this
> is what i got :
>
> Caused by: org.postgresql.util.PSQLException: ERROR: insert or update on
> table "poi" violates foreign key constraint "poi_id_cat_fkey"
> Detail: Key (id_cat)=(0) is not present in table "poi_categ".
> at
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
>
> Now programatically this could be settled with an input box asking for an FK
> value that respects the constraints on that att, but i'm curious why this
> hasn't been implemented in udig(is there maybe an even easier solution which
> i'm missing? maybe an option which i did not activate?)
I am not sure what to make of this error? it sounds like a problem coming out
of your database? Did you create the table with the datastore createSchema?
Usually we do not run the tables with much by way of constraints (beyond what
postgis applies).
> And... why does each postgis layer have two renderers? (in layer view they
> appear only once)
>
Often they have two a) one for the content and b) one for the selection (if you
select something).
Jody
_______________________________________________
User-friendly Desktop Internet GIS (uDig)
http://udig.refractions.net
http://lists.refractions.net/mailman/listinfo/udig-devel
