Re: simulating partial fkeys..

Поиск
Список
Период
Сортировка
От Jan Wieck
Тема Re: simulating partial fkeys..
Дата
Msg-id 3EE07C96.6090400@Yahoo.com
обсуждение исходный текст
Ответ на simulating partial fkeys..  (<mallah@trade-india.com>)
Список pgsql-sql
mallah@trade-india.com wrote:
> 
> hi ,
> 
> Is there any way to enforce fkeys only on subset of
> the table something on the lines of unique partial indexes

Sure. Put NULL values into the referencing fields of those rows you 
don't want to be checked.


Jan

-- 
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #



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

Предыдущее
От: Bruno Wolff III
Дата:
Сообщение: Re: simulating partial fkeys..
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: simulating partial fkeys.. [ATTN Developers please]