Setting Foreign Key - Error

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)