Re: Not In Foreign Key Constraint

From: David Johnston <polobo(at)yahoo(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Not In Foreign Key Constraint
Date: 2013-09-19 18:09:58
Message-ID: 1379614198404-5771651.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Misa Simic wrote
> Hi hackers,
>
> I just wonder how hard would be to implement something like "Not In FK
> Constraint" or opposite to FK...

A more useful couple next sentences would be along the lines of:

I have this problem....I've approached it by doing....but it seems that an
actual database enforced constraint would be a better solution. Is that
something that has been considered? Are their other ways of attacking this
problem I have not considered?

You took quite a bit of time to try and start a discussion, and I get that
you don't necessarily know where it is going to lead, but "Not In FK
constraint", with a descriptive sentence of two, likely would have been
enough to get the ball rolling. Instead you devoted more space to technical
clarification that would have been better served by espousing on "what
problem" and how current approaches to dealing with said problem are
limited.

A more specific end-question would also help solicit better responses.

I say all this because 3 days later nothing more substantial than "why is
this feature necessary" has been put forth. The general idea likely has
some merit but you've not provided anything for people to hook their teeth
into.

David J.

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Not-In-Foreign-Key-Constraint-tp5771056p5771651.html
Sent from the PostgreSQL - hackers mailing list archive at Nabble.com.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2013-09-19 18:39:43 Re: [PERFORM] encouraging index-only scans
Previous Message Robert Haas 2013-09-19 17:54:41 Re: Where to load modules from?