On 04/06/2012 02:40 PM, Guillaume Lelarge wrote:
On Fri, 2012-04-06 at 08:03 -0400, Colin Beckingham wrote:
Given 3 tables, authors, books and words, each has a primary key.
Attempting to use pgadmin to add a foreign key to books to link authors
to books, and a key to words to link words to books.
The first step works ok (ignoring previously reported backtrace) and the
foreign key is added to books linking it to authors. However when
attempting to add a foreign key to words, pgadmin can still only see the
authors table as a reference table.
Tried reloading and refreshing but pgadmin does not seem to see beyond
the authors table for the 'referencing' dropdown.
Maybe I am missing a step. table books definitely has a primary key.
Can you give us your tables' definition? Thanks.
CREATE TABLE authors
(
authid serial NOT NULL,
name character varying(250) NOT NULL,
CONSTRAINT authors_pkey PRIMARY KEY (authid )
);
CREATE TABLE books
(
bookid serial NOT NULL,
authid integer NOT NULL,
title character varying(250) NOT NULL,
CONSTRAINT books_pkey PRIMARY KEY (bookid ),
CONSTRAINT books_authid_fkey FOREIGN KEY (authid)
REFERENCES authors (authid) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION,
CONSTRAINT books_bookid_key UNIQUE (bookid )
);
CREATE TABLE words
(
wordid serial NOT NULL,
lemma character varying(100),
bookid integer,
wcount integer,
CONSTRAINT words_pkey PRIMARY KEY (wordid )
);
CREATE INDEX words_bookid_idx
ON words
USING btree
(bookid );
--
---
Colin Beckingham
613-454-5369
http://www.it4gh.com
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support