Re: enum bug - Mailing list pgsql-general

From Andrew Sullivan
Subject Re: enum bug
Date
Msg-id 20160314164343.GF84411@crankycanuck.ca
Whole thread Raw
In response to Re: enum bug  (Melvin Davidson <melvin6925@gmail.com>)
List pgsql-general
On Sun, Mar 13, 2016 at 10:20:05PM -0400, Melvin Davidson wrote:
> The point is, they are an archaic data type and it's a hell of a lot easier
> to use Foreign Keys to insure integrity.

So don't use them?  Nobody, surely, is forcing you to use enums.

I recall when enums were added.  I recall thinking at the time that
they were a bad idea and that you should do such things properly with
CHECK constraints and so on.  But people wanted them because lots of
(IMO poor) designs rely on them.  That seems like a good reason to me
to keep them around, and not to use them :)

Best regards,

A

--
Andrew Sullivan
ajs@crankycanuck.ca


pgsql-general by date:

Previous
From: Melvin Davidson
Date:
Subject: Re: enum bug
Next
From: Pujol Mathieu
Date:
Subject: Re: Unexpected result using floor() function