Re: Array of foreign key

On 2017-12-23 14:40:13 -0500, Melvin Davidson wrote:
> On Sat, Dec 23, 2017 at 2:27 PM, Peter J. Holzer <hjp-pgsql(at)hjp(dot)at> wrote:
> >If you do not understand something, please ask.
>
> Your response is inappropriate and offensive.

I apologize for my tone. I should have calmed down before replying.

I do not apologize for the substance, though. I think it is entirely
appropriate to point out inappropriate and offensive behaviour, and I
think it is more helpful to point out the specific aspects that one
finds inappropriate and offensive than just making a blanket claim.

To repeat:

* I think it is offensive to claim that somebody doesn't understand some
basic aspect of RDBMSs unless that person has written something which
is clearly false. This is a list about an RDBMS and one should assume
that most of the people here (or at least the regular contributors)
know at least the basics. Since you were apparently aware that you
didn't understand what I was writing about, it would have been
appropriate to consider that you might have misunderstood whatever you
thought I had written about foreign keys.

* I think it is impolite not to take the 2 seconds to check who you are
replying to. I understand that in a long thread it is easy to lose
track of who started it and who wrote what, but this thread wasn't
that long.

* I think it is inappropriate to ask some random participant in the
middle of a discussion what OS and PostgreSQL version they are
running, unless they have related some specific observation about
their system. Even if I had not been a random participant, but the OP,
I would have considered the question inappropriate, since at that
point in the discussion it should have been clear that none of the
topics (arrays, enums, foreign keys, ...) is dependent on the exact
PostgreSQL version, much less the OS.

> I specifically asked for clarification because the op stated "column
> which is an array of a foreign key" but gave no details.
>
> >Don't claim that other people "don't understand how X works"
> Again, from the op's reference to using constraint's and triggers, it seemed
> like the op did not fully understand the FK's would do the same.

AFAICS the OP didn't mention triggers at all. Ken and I mentioned them
as a way to simulate what the OP wanted.

> Also, it is not necessary to state which version I PostgreSQL I use, because
> that is irrelevant.

It is also irrelevant what version of PostgreSQL I use (or what version
Ken or Andreas use). The version the OP uses might have been mildly
interesting at the start of the discussion.

hp

--
_ | Peter J. Holzer | we build much bigger, better disasters now
|_|_) | | because we have much more sophisticated
| | | hjp(at)hjp(dot)at | management tools.
__/ | http://www.hjp.at/ | -- Ross Anderson <https://www.edge.org/>