Skip site navigation (1) Skip section navigation (2)

Cannot Create Foreign Key

From: "Shane G(dot) Brodie" <sgbrodie(at)mts(dot)net>
To: pgadmin-support(at)postgresql(dot)org
Subject: Cannot Create Foreign Key
Date: 2004-09-18 05:02:55
Message-ID: 1095483774.17917.10.camel@eoraptor (view raw or whole thread)
Lists: pgadmin-support
App:	pgAdminIII V1.2.0 Post Beta 1 (Sept 17 2004)
DB:	PostgreSQL 7.4.2
O/S:	Fedora Core 2
Kernel: 2.6.8-1.521

Cannot add a foreign key to a table using the gui provided by the "New
Object" ... "Foreign Key" dialog.  The dialog appears complete and I
have filled out all of the requisite parts of the dialog.  On the
"Columns" tab, the two related columns are selected, but the "Add"
button remains grayed out.


Shane Brodie
Winnipeg, Manitoba, Canada

PS:  SQL for the 2 tables in case I've lost my marbles and am trying to
do something I shouldn't be, is included below.

  emp_id serial NOT NULL,
  familyname varchar(30) NOT NULL,
  givennames varchar(30) NOT NULL,
  sinnumber varchar(9),
  dob date,
  photo_path varchar(255),
  CONSTRAINT pk_emp_tb PRIMARY KEY (emp_id)

CREATE TABLE emp_address_tb
  emp_id int4 NOT NULL,
  address_id serial NOT NULL,
  add1 varchar(100) NOT NULL,
  add2 varchar(100),
  city varchar(50) NOT NULL,
  prov_cd char(2) NOT NULL,
  postalcd char(6),
  CONSTRAINT pk_emp_address PRIMARY KEY (address_id)

Relation I'm trying to establish is between emp_tb.emp_id and
emp_address_tb.emp_id ...


pgadmin-support by date

Next:From: Andreas PflugDate: 2004-09-18 08:31:14
Subject: Re: Can't change server Initial DB property //
Previous:From: Ted TaylorDate: 2004-09-18 01:07:44
Subject: Can't change server Initial DB property // Refresh server properties

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group