Re: referential integrity violation - Mailing list pgsql-general

From Stephan Szabo
Subject Re: referential integrity violation
Date
Msg-id Pine.BSF.4.21.0107300950470.95589-100000@megazone23.bigpanda.com
Whole thread Raw
In response to referential integrity violation  (tony <tony@animaproductions.com>)
List pgsql-general
It means that the particular key value that is used in the referencing
table does not have an associated value in the referenced table,
not the columns themselves.

On 30 Jul 2001, tony wrote:

> Hello,
>
> While copying from a text file of tab delimited data I am getting
> " ERROR: <unnamed> referential integrity violation - key referenced
> from films not found in sales"
>
> The salesid field
> salesid INTEGER PRIMARY KEY DEFAULT NEXTVAL('sales_serial')
>
> exists
>


pgsql-general by date:

Previous
From: Mike Finn
Date:
Subject: Unexpected *ABORT STATE*
Next
From: Barry Lind
Date:
Subject: Re: Re: "Oracle's ROWNUM"