Table inheritance, unique constraints and foreign key problem

Поиск
Список
Период
Сортировка
От Jacob Rief
Тема Table inheritance, unique constraints and foreign key problem
Дата
Msg-id 1196117799.4612.20.camel@ruben
обсуждение исходный текст
Ответы Re: Table inheritance, unique constraints and foreign key problem  (Gregory Stark <stark@enterprisedb.com>)
Список 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 по дате отправления:

Предыдущее
От: Gregory Stark
Дата:
Сообщение: Re: Replacement Selection
Следующее
От: Mark Cave-Ayland
Дата:
Сообщение: Re: Locating sharedir in PostgreSQL on Windows