Re: Foreign keys to inherited tables

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