Обсуждение: 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
>