I am attempting to add a table with a foreign key referencing the
primary key of another table in the same schema. When I try to add the
foreign key constraint, the Add button under the Columns tab is always
disabled. I must be doing something incorrectly, and I'd like an idea
as what I need to change. I am using pgAdmin III 1.02 under Linux.
For example, if I have a table:
CREATE TABLE development.referenced
(
id int4 NOT NULL,
CONSTRAINT referenced_id_pkey PRIMARY KEY (id)
) WITHOUT OIDS;
And another table:
CREATE TABLE development.referencer
(
referenced int4 NOT NULL
) WITHOUT OIDS;
I could like to add the constraint that
development.referencer.referenced is a foreign key to the other table.
I can do so in psql with:
ALTER TABLE development.referencer ADD FOREIGN KEY (referenced)
REFERENCES development.referenced (id);
I can't do this using the dialogs in pgAdmin III, however. Any ideas
why?
Thanks in advance...
Ryan Adams
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
