Thread: 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 FKcolumn and it does no allow me to insert "" around MNo. I think "add column" wizard uses ""s internally, but FK wizarddoesn'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)
Hi Cagil, Can you please try the updated .exe file from: http://cvs.pgadmin.org/cgi-bin/viewcvs.cgi/~checkout~/binaries/pgadmin2.exe?rev=1.79 Thanks, Dave. > -----Original Message----- > From: Çagil Seker [mailto:cagils@biznet.com.tr] > Sent: 02 December 2002 12:08 > To: PGAdmin-Support-List (E-mail) > Subject: [pgadmin-support] 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) > > ---------------------------(end of > broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to > majordomo@postgresql.org >