Postgres Pro
Downloads
Home   >   mailing lists

constrain with MATCH full and NULL values in referenced table - Mailing list pgsql-general

From stan
Subject constrain with MATCH full and NULL values in referenced table
Date
Msg-id 20190812151115.GA8819@panix.com
Whole thread Raw
Responses Re: constrain with MATCH full and NULL values in referenced table
Re: constrain with MATCH full and NULL values in referenced table
Re: constrain with MATCH full and NULL values in referenced table
List pgsql-general
Tree view 
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 by date:

Previous
From: Adrien Nayrat
Date:
Subject: Re: Fwd: Postgres HA - pacemaker RA do not support auto failback
Next
From: Adrian Klaver
Date:
Subject: Re: constrain with MATCH full and NULL values in referenced table