constrain with MATCH full and NULL values in referenced table

Поиск
Список
Период
Сортировка
От stan
Тема constrain with MATCH full and NULL values in referenced table
Дата
Msg-id 20190812151115.GA8819@panix.com
обсуждение исходный текст
Ответы Re: constrain with MATCH full and NULL values in referenced table  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: constrain with MATCH full and NULL values in referenced table  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: constrain with MATCH full and NULL values in referenced table  (Francisco Olarte <folarte@peoplecall.com>)
Список pgsql-general
I am creating a table that has 2 values in it which are keys pointing to 2
other tables. I need for the UNIQUE combination of these 2 keys to exist in
a fourth table. It has been recommended to use a foreign key constraint with
the MATCH FULL parameter. 

Here is my question, does this deal with NULLS in the 4th table? I am
concerned that this constraint might fail to reject an entry if one, or both
of the 2 key values being inserted in the table are NULLS,.



-- 
"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
                        -- Benjamin Franklin



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

Предыдущее
От: Adrien Nayrat
Дата:
Сообщение: Re: Fwd: Postgres HA - pacemaker RA do not support auto failback
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: constrain with MATCH full and NULL values in referenced table