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:[EMAIL PROTECTED]] > 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 > [EMAIL PROTECTED] > ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]