Andreas,
1. The table does have a PK.
2. It used to work in pgAdmin III 1.0.2
3. Could it be that one field is int4 and the other is declared as a serial field? - Just a thought.
Ben
From: Andreas Pflug <[EMAIL PROTECTED]> To: Ben Trewern <[EMAIL PROTECTED]> CC: [EMAIL PROTECTED] Subject: Re: [pgadmin-support] Can't create foreign keys Date: Mon, 23 Aug 2004 10:23:47 +0000
Ben Trewern wrote:I'm testing pgAdmin III Aug 15 snapshot and have found that you can't add foreign keys.
You go to your table of choice then:
Properties -> Constraints -> Add -> Pick table in References drop down -> Pick a field in Local column -> No fields show up in Referencing!
Then the table has no PK and is unsuitable as a referenced table.
Regards, Andreas
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
_________________________________________________________________
Want to block unwanted pop-ups? Download the free MSN Toolbar now! http://toolbar.msn.co.uk/
---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
