Re: Allow composite foreign keys to reference a superset of unique constraint columns?

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Paul Martinez <hellopfm(at)gmail(dot)com>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Allow composite foreign keys to reference a superset of unique constraint columns?
Date: 2021-08-17 00:00:58
Message-ID: CAKFQuwZjyDepQSuPA0jCLVZy3DzKneqEeDjchU80OL63=ek=EQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Aug 16, 2021 at 4:37 PM Paul Martinez <hellopfm(at)gmail(dot)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.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Greg Nancarrow 2021-08-17 00:07:03 Re: Re[5]: On login trigger: take three
Previous Message Paul Martinez 2021-08-16 23:36:40 Allow composite foreign keys to reference a superset of unique constraint columns?