So my question is: Aren't primary keys inherited in Postgres?
Straight from the manual at: http://www.postgresql.org/docs/current/static/ddl-inherit.html
Originally Posted by Postgres manual
All check constraints and not-null constraints on a parent table are automatically inherited by its children. Other types of constraints (unique, primary key, and foreign key constraints) are not inherited.