schemes.sql (mal wieder)

From: Alexander Wirt (formorer@formorer.de)
Date: Sat May 11 2002 - 20:30:36 CEST


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)

mfg alex

-- 
Alexander "formorer" Wirt	KeyID: BC7D020A 	
EMail: formorer@formorer.de	ICQ: 28651245



This archive was generated by hypermail 2.1.3 : Sat May 11 2002 - 20:47:07 CEST