Hi, I get an error when trying to add a foreign key constraint:
"CREATE TABLE: column "mno" referenced in foreign key consraint does not exist" Yes, it does not exist because it is "MNo" not "mno". But foreign key form of pgAdmin has a combo box that I select my FK column and it does no allow me to insert "" around MNo. I think "add column" wizard uses ""s internally, but FK wizard doesn't which I think is an error. Am I wrong? Also, when I change my column name to "mno" from "MNo", it gives that error: "UNIQUE constraint matching gives keys for referenced table "Manufacture" not found" NOTE: "Manufacture"s primary key is "No". I also have a table named say "XXX" which has a FK named "MNo" referencing "Manufacture"s "No". What should I do instead? Cagil SEKER ----------------- "Yes, I am a criminal. My crime is that of outsmarting you. Something that you'll never forgive me for!" - The Mentor'86 (Hacker's Manifesto) ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
