Re: [HACKERS] Foreign keys: unexpected result from ALTER TABLE... ADD CONSTRAINT...

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [HACKERS] Foreign keys: unexpected result from ALTER TABLE... ADD CONSTRAINT...
Дата
Msg-id 20873.948124695@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [HACKERS] Foreign keys: unexpected result from ALTER TABLE... ADD CONSTRAINT...  ("Oliver Elphick" <olly@lfix.co.uk>)
Список pgsql-hackers
Дерево обсуждения 
"Oliver Elphick" <olly@lfix.co.uk> writes:
> I guess I will have to remove the restriction that products listed in
> product_suppliers must be purchased; it may indeed become possible for the
> to change status from time to time, so that is not too unsatisfactory.

You could possibly enforce dependencies like that by using a trigger
function, instead of foreign-key stuff.
        regards, tom lane

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Jan Wieck
Дата:
Сообщение: Re: [HACKERS] pg_dump not in very good shape
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: [HACKERS] RE: Getting rid of setheapoverride (was Re: [COMMITTERS] heap.c)