Re: schemes.sql (mal wieder)

From: Erik Tews (erik.tews@gmx.net)
Date: Sat May 11 2002 - 21:23:25 CEST

On Sat, May 11, 2002 at 08:30:36PM +0200, Alexander Wirt wrote:
> Ich hab mal wieder Probleme beim einspielen der scheme.sql in eine
> frische DB:
>
> formorer@lisa:~/linuxtag/tmp$ createdb ltag-2002
> CREATE DATABASE
> formorer@lisa:~/linuxtag/tmp$cat ../ltp/scheme.sql ltag-2002
> dabei kommt folgendes: (nur die Fehler ! ich hab den Rest rausgefiltert)
>
> formorer@lisa:~/linuxtag/ltp$ cat scheme.sql | psql ltag-2002 -o db.out
> NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s)
> ERROR: <unnamed> referential integrity violation - key referenced from nili not found in person
> ERROR: <unnamed> referential integrity violation - key referenced from nili not found in person
> ERROR: <unnamed> referential integrity violation - key referenced from nili not found in person
> ERROR: <unnamed> referential integrity violation - key referenced from nili not found in person
> ERROR: <unnamed> referential integrity violation - key referenced from nili not found in person
> ERROR: <unnamed> referential integrity violation - key referenced from nili not found in person
> ERROR: <unnamed> referential integrity violation - key referenced from nili not found in person
> ERROR: <unnamed> referential integrity violation - key referenced from nili not found in person
> ERROR: <unnamed> referential integrity violation - key referenced from nili not found in person
> ERROR: <unnamed> referential integrity violation - key referenced from nili not found in person
> ERROR: <unnamed> referential integrity violation - key referenced from nili not found in person
> NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s)
> ERROR: DefineIndex: attribute "name" not found
> NOTICE: CREATE TABLE will create implicit sequence 'job_id_seq' for SERIAL column 'job.id'
> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'job_pkey' for table 'job'
> NOTICE: CREATE TABLE will create implicit sequence 'jobfragment_id_seq' for SERIAL column 'jobfragment.id'
> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'jobfragment_pkey' for table 'jobfragment'
> NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s)
> NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s)

Also, was genau schiefgeht weis ich nicht.

Aber irgendwie ist dein psql etwas merkwürdig. Die Zeilen die mit --
beginnen sollte er eigentlich ignorieren.

This archive was generated by hypermail 2.1.3 : Sat May 11 2002 - 21:25:40 CEST