Table inheritance, unique constraints and foreign key problem - Mailing list pgsql-hackers

From Jacob Rief
Subject Table inheritance, unique constraints and foreign key problem
Date
Msg-id 1196117799.4612.20.camel@ruben
Whole thread Raw
Responses Re: Table inheritance, unique constraints and foreign key problem  (Gregory Stark <stark@enterprisedb.com>)
List pgsql-hackers
Hello,
this issue has been requested and its on the TODO-list. Since I really
need foreign key constraints on inherited tables, I have two solutions:
Adding some hackish RULES/TRIGGERS to my tables or implementing it
myself. It think the latter is better. However, I have no experience in
implementing such a feature in Postgres. I have written some triggers in
C (actually C++) using the SPI_-functions, but that's it. I have a
running 8.3beta, checked out from the repository, and I have read the
Ottawa slides. Can someone tell me in a few lines, where to start with
such a feature.
Jacob




pgsql-hackers by date:

Previous
From: Gregory Stark
Date:
Subject: Re: Replacement Selection
Next
From: Mark Cave-Ayland
Date:
Subject: Re: Locating sharedir in PostgreSQL on Windows