Primary key not inherited

goocreations · #1 (**permalink**) 04-16-11, 05:01

I have a simple inheritance structure:

Code:

CREATE TABLE nature_reserve
(
	the_id SERIAL PRIMARY KEY,
	the_name VARCHAR
);

CREATE TABLE private_nature_reserve
(
) INHERITS (nature_reserve);

CREATE TABLE reserve_license
(
	the_id SERIAL PRIMARY KEY,
	the_reserve INTEGER REFERENCES private_nature_reserve(the_id)
);

When I run this script I get the following error:

Code:

ERROR:  there is no unique constraint matching given keys for referenced table "private_nature_reserve"

So my question is: Aren't primary keys inherited in Postgres?

shammat · #2 (**permalink**) 04-16-11, 05:53

Quote:

Originally Posted by goocreations

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

Quote:

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.

goocreations · #3 (**permalink**) 04-16-11, 06:00

Thank you!

Internet Services

Web Development

Digital Marketing

Consumer Tech