Skip site navigation (1) Skip section navigation (2)

Re: Problem in populating tables

From: Doug Gorley <douggorley(at)shaw(dot)ca>
To: dorellik1 <dorellik1(at)inwind(dot)it>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Problem in populating tables
Date: 2003-01-26 23:26:45
Message-ID: 1043623605.2028.44.camel@h24-69-83-179.ca.shawcable.net (view raw or flat)
Thread:
Lists: pgsql-novice
Well, from the looks of it, the error messages say it all.  You're
trying to create constraints of existing data that doesn't comply.  Have
you checked your data to make sure that the constraints you're trying to
introduced are already reflected in the existing data?

On Sun, 2003-01-26 at 12:54, dorellik1 wrote:
> To populate the tables of a database ( drawn from a book )I 
> have followed two strategies.
> The first one :
>  
> 1)I create the tables without any definition of foreign keys.
> 2)I have altered the tables to add the foreign keys.
> 3)I populate the tables obtaining error ( obvious ).
>  
> The second one :
>  
> 1)I create the tables without any definition of foreign keys.
> 2)I populate the tables without obtaining any error.
> 3)I have altered the tables to add the foreign keys with three 
>   error out seven ALTER TABLE --- .
>  
> I think that the sql to create and alter the table is lawfull
> because in the first try the steps 1) and 2) execute flawless.
>  
> Then where is the problem ?
>  
> In sqlcode.txt there is the sql to create and alter the tables.
>  
> In error.txt there are the reported errors.
>  
> The postgresql version is 7.2.2 on a Mandrake 9.0.
>  
>                
>                                      Thanks.
> 
> ______________________________________________________________________
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org


In response to

pgsql-novice by date

Next:From: Art ForeDate: 2003-01-26 23:36:29
Subject: Re: postgresql with SuSE 8.0
Previous:From: Ben PrescottDate: 2003-01-26 23:16:00
Subject: Re: postgresql with SuSE 8.0

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group