Re: Stuck on Foreign Keys - Mailing list pgsql-general

From Michael Glaesemann
Subject Re: Stuck on Foreign Keys
Date
Msg-id B0145232-7C11-4D1D-B776-708D76356A01@seespotcode.net
Whole thread Raw
In response to Stuck on Foreign Keys  (Chester <chester@hica.com.au>)
Responses Re: Stuck on Foreign Keys
List pgsql-general
On Sep 19, 2007, at 23:13 , Chester wrote:

> ERROR:  insert or update on table "clients" violates foreign key
> constraint "the_title"
> DETAIL:  Key (ticode)=( ) is not present in table "titles".
>
> Sorry, I have no idea where I  am going wrong...Any help would be
> great

You've shown us the errors but not the commands you used that threw
the errors. Show us the exact commands you used along with the errors
so we might see what's going wrong. It looks like you're not
providing a value for ticode when inserting or updating clients, but
that's just a guess.

Michael Glaesemann
grzm seespotcode net



pgsql-general by date:

Previous
From: Chester
Date:
Subject: Stuck on Foreign Keys
Next
From: Chester
Date:
Subject: Re: Stuck on Foreign Keys