Re: Strange bug

"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