Re: multiple UNIQUE indices for FK

W dniu 01.03.2016 o 20:02, Igor Neyman pisze:
[--------------------]
>
>
> It just occured to me: how do I make sure (e.g. force within a database) with the above structure, that a message can
have*only  one* sender? 
> but, allow for multiple recepients?
>
> -R
>
> ____________________________________________________________________________________
>
> If I'm not too late, unique partial index:
>
> CREATE UNIQUE INDEX unique_message_sender (message_id, person_id) WHERE relationship_type = sender;
>

Of cource.

Apparently I'm so twisted after the numerous rewrites of my schema for
this project, that I forget the obvious.


Thenx,

-R