Re: Allow composite foreign keys to reference a superset of unique constraint columns? - Mailing list pgsql-hackers

From David G. Johnston
Subject Re: Allow composite foreign keys to reference a superset of unique constraint columns?
Date
Msg-id CAKFQuwZjyDepQSuPA0jCLVZy3DzKneqEeDjchU80OL63=ek=EQ@mail.gmail.com
Whole thread Raw
In response to Allow composite foreign keys to reference a superset of unique constraint columns?  (Paul Martinez <hellopfm@gmail.com>)
Responses Re: Allow composite foreign keys to reference a superset of unique constraint columns?  (Jack Christensen <jack@jncsoftware.com>)
List pgsql-hackers
On Mon, Aug 16, 2021 at 4:37 PM Paul Martinez <hellopfm@gmail.com> wrote:

It seems like a somewhat useful feature. If people think it would be useful to
implement, I might take a stab at it when I have time.


This doesn't seem useful enough for us to be the only implementation to go above and beyond the SQL Standard's specification for the references feature (I assume that is what this proposal suggests).

This example does a good job of explaining but its assumptions aren't that impactful and thus isn't that good at inducing desirability.

David J.

pgsql-hackers by date:

Previous
From: Paul Martinez
Date:
Subject: Allow composite foreign keys to reference a superset of unique constraint columns?
Next
From: Greg Nancarrow
Date:
Subject: Re: Re[5]: On login trigger: take three