[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 08:55:08 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):

 The layer table is being populated _before_ the topology table. May be the
 cause of it:
 {{{
 5170407:COPY layer (topology_id, layer_id, schema_name, table_name,
 feature_column, feature_type, level, child_id) FROM stdin;
 5170438:COPY topology (id, name, srid, "precision", hasz) FROM stdin;
 }}}

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