"Leif B. Kristensen" <leif@solumslekt.org> writes:
> I just noticed that I accidentally got a duplicate id. My
> definitions are here:
> CREATE TABLE citations (
> citation_id INTEGER PRIMARY KEY,
> source_fk INTEGER REFERENCES sources (source_id)
> );
> CREATE TABLE relation_citations (
> relation_fk INTEGER REFERENCES relations (relation_id)
> ) INHERITS (citations);
relation_citations doesn't have a primary key. See
http://www.postgresql.org/docs/8.1/static/ddl-inherit.html
particularly the "caveats" section.
regards, tom lane