On 8/18/2004 9:49 AM, Markus Bertheau wrote:
Ð ÐÑÐ, 18.08.2004, Ð 15:33, Jan Wieck ÐÐÑÐÑ:
Meaning that not enforcing the uniqueness of those columns isn't an option.
The thing is that the columns _are_ unique, there's just no unique constraint on them. They are unique because there's a unique constraint on a subset of these columns. So no additional uniqueness enforcing needed.
Yes, you are right, a superset of columns of a unique constraint is allways unique as well.
I assume it is performance why you are denormalizing your data?
However, Bruce, this should be on the TODO list:
* Allow foreign key to reference a superset of the columns covered by a unique constraint on the referenced table.
Jan
-- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #================================================== [EMAIL PROTECTED] #
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend