Re: Stuck on Foreign Keys

From: Michael Glaesemann <grzm(at)seespotcode(dot)net>
To: Chester <chester(at)hica(dot)com(dot)au>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Stuck on Foreign Keys
Date: 2007-09-20 05:04:26
Message-ID: B0145232-7C11-4D1D-B776-708D76356A01@seespotcode.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Benjamin Smith 2007-09-20 05:18:41 Re: Is this good spec for a PostgreSQL server?
Previous Message Benjamin Smith 2007-09-20 04:59:47 Re: Stuck on Foreign Keys