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]

Reply via email to