[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 15:02:53 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):

 Another alternative could be disabling triggers on the two tables. Will
 try that as well before committing. This other alternative has the
 advantage of having no need to convert the table later.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1371#comment:4>
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