[postgis-devel] [PostGIS] #1371: postgis_restore.pl: insert or update on table "layer" violates foreign key constraint "layer_topology_id_fkey"

PostGIS trac at osgeo.org
Tue Dec 13 14:51:51 PST 2011


#1371: postgis_restore.pl: insert or update on table "layer" violates foreign key
constraint "layer_topology_id_fkey"
----------------------+-----------------------------------------------------
 Reporter:  strk      |       Owner:  strk         
     Type:  defect    |      Status:  new          
 Priority:  medium    |   Milestone:  PostGIS 2.0.0
Component:  topology  |     Version:  trunk        
 Keywords:            |  
----------------------+-----------------------------------------------------

Comment(by strk):

 Tried and works fine.
 But comparing the tables between 1.5 and 2.0 there's a difference in
 topology.topology which has an additional field. We would then need a
 function that adds the field if missing from the table in the dump. But
 only if the dump does have topology...

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1371#comment:3>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.


More information about the postgis-devel mailing list