Re: Foreign keys to inherited tables - Mailing list pgsql-general

From brian
Subject Re: Foreign keys to inherited tables
Date
Msg-id 47E1DD2B.70207@zijn-digital.com
Whole thread Raw
In response to Foreign keys to inherited tables  ("Leon Mergen" <leon@solatis.com>)
Responses Re: Foreign keys to inherited tables
List pgsql-general
Leon Mergen wrote:
> Hello,
>
> I was wondering, I'm reading that there is no support for foreign keys
> to inherited (child) tables -- are there any plans on supporting these
> in the (near) future, and/or are there any practical workarounds for
> this ?
>

This has worked well for me:

CREATE TABLE child_table (
     ...
) INHERITS (parent_table);

ALTER TABLE child_table ALTER COLUMN id SET DEFAULT
nextval('parent_table_id_seq');

CREATE UNIQUE INDEX child_table_pk ON child_table (id);

Note that it's not necessary to declare an id column for the child.

b

pgsql-general by date:

Previous
From: "- Edwin -"
Date:
Subject: Re: Which JDBC version to use with PostgreSQL 8.1.11?
Next
From: "Brent Wood"
Date:
Subject: Postgres development