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