Michael Glaesemann wrote:
On Sep 19, 2007, at 23:13 , C 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
Thanks Michael
The table's are existing populated table the error was happening
whilst altering the client table to add the FC, sorry if that was not
clear. Maurice put me right there were a couple of rows in the client
table with null values in the ticode column.
Thanks again guys
Cheers
C
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
