[Mapbender-users] foreign key constraints error while restoring Mapbender-postgis-installation

[Christoph Baudson (WhereGroup)]

Hi Marco,

try this:

http://www.mapbender.org/index.php/Database_Changes_2.4.1#layer_epsg

Cheers,

Christoph


Marco Lechner schrieb:
> Hi list,
> 
> we are running into trouble, trying to restore our mapbender
> installation from postgresql8.0.2/posgis1.0.0 to
> postgresql8.2.4/postgis1.2.1:
> 
> During the restoration of the succesful created dump we are receiving
> errormessages like:
> 
> ERROR: insert or update on table "layer_epsg" violates foreign key
> constraint "layer_epsg_ibfk_1"
> SQL Status:23503
> Detail:Key (fkey_layer_id)=(14007) is not present in table "layer".
> 
> Having a look to the according tables the error message is correct,
> because the fkey_layer_id=14007 doesn't exist in the table layer. What
> we don't get is that the foreign key constraint exists in the old
> installation and it was created there by the
> resources/db/postgresql/pgsql_schema.sql ignoring the inconsistent data.
> But it fails to create the foreign key constraint in the new
> installation and manually in the old installation either now. We have no
> idea how it worked at the initial installation.
> 
> Does anybody have an idea how we could get out of this?
> 
> Marco & Steffen
> 
> _______________________________________________
> Mapbender_users mailing list
> Mapbender_users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapbender_users


-- 
---------------------------------------
WhereGroup GmbH & Co. KG
Siemensstraße 8
53121 Bonn
Germany

Fon: +49 (0)228 / 90 90 38 - 17
Fax: +49 (0)228 / 90 90 38 - 11

mailto:info at wheregroup.com
http://www.wheregroup.com
Amtsgericht Bonn, HRA 6788
-------------------------------
Komplementärin:
WhereGroup Verwaltungs GmbH
vertreten durch:
Arnulf Christl, Olaf Knopp, Peter Stamm
---------------------------------------


--
Baudson Christoph
http://www.wheregroup.com