foreign key check

Поиск
Список
Период
Сортировка
Искать
От
David Gardner
Тема
foreign key check
Дата
Msg-id
467727AB.5020300@gardnerit.net
Список
Дерево обсуждения
foreign key check David Gardner <david@gardnerit.net>
Re: foreign key check Tom Lane <tgl@sss.pgh.pa.us>
I have two tables t1, and t2 where t2.fid is a foreign key reference to 
t1.id. Except in this case only a subset of the values in t1 are valid, 
the values in t1 that are valid can be found by doing a:
SELECT t1.id JOIN t3 ON t3.id = t1.id
Is there some way to add this in as a check constraint? I could just 
write a pl/pgsql function to perform a check before inserting, but I am 
beginning to suspect that the reason I am running into this is because 
my schema isn't accurately representing the business logic of the 
application.
В списке pgsql-novice по дате отправления
От: David Gardner
Дата:
Сообщение: Re: foreign key check
От: Tom Lane
Дата:
Сообщение: Re: foreign key check
FAQ