Re: referential integrity violation

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: tony <tony(at)animaproductions(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: referential integrity violation
Date: 2001-07-30 16:51:46
Message-ID: Pine.BSF.4.21.0107300950470.95589-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2001-07-30 17:05:39 Re: RULE vs TRIGGER
Previous Message Barry Lind 2001-07-30 16:50:28 Re: Re: "Oracle's ROWNUM"