Re: Array of foreign key - Mailing list pgsql-general

From Andreas Kretschmer
Subject Re: Array of foreign key
Date
Msg-id B4846243-6401-4BF0-828C-BB3906DA423C@a-kretschmer.de
Whole thread Raw
In response to Re: Array of foreign key  (Melvin Davidson <melvin6925@gmail.com>)
Responses Re: Array of foreign key
List pgsql-general
>Please DO NOT use EMUMs. That is old. They are hard to maintain. I also
>know from experience that MySql does not check
>integrity of enums. It's possible you can have data in a MySql table
>column
>that is not valid for current enum constraint on that column.
>EG: When porting, the enum for a columm (VALID) was "yes, no", but I
>found
>a few that had "maybe" as data.
>
>The way to go is to simply implement FOREIGN KEYs. Much easier to
>maintain
>in PostgreSQL.


Full ack.

Andreas


--
2ndQuadrant - The PostgreSQL Support Company


pgsql-general by date:

Previous
From: Melvin Davidson
Date:
Subject: Re: Array of foreign key
Next
From: Jeremy Finzel
Date:
Subject: Problem with pgq3 packages missing pgq_node