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

[Marco Lechner]

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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: marco.lechner.vcf
Type: text/x-vcard
Size: 345 bytes
Desc: not available
Url : http://lists.osgeo.org/pipermail/mapbender_users/attachments/20070522/e1430547/marco.lechner.vcf