Search Postgresql Archives

Re: Stuck on Foreign Keys

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




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



---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

              http://archives.postgresql.org/

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux