Re: schemes.sql (mal wieder)

From: Alexander Wirt (formorer@formorer.de)
Date: Sat May 11 2002 - 21:39:47 CEST


On Sat, May 11, 2002 at 09:23:25PM +0200, Erik Tews wrote:
> 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.
Ich hab ein stinknormales psql aus sid.....
Kann mir das auch nicht so recht erklären.

mfg alex

>
> --
> To UNSUBSCRIBE, send an email to linuxtag-ltp-request@lists.infodrom.org
> with a subject of "unsubscribe". Trouble? Contact listmaster@lists.infodrom.org
>
>

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



This archive was generated by hypermail 2.1.3 : Sat May 11 2002 - 21:39:24 CEST