Re: Array of foreign key - Mailing list pgsql-general
On Fri, Dec 22, 2017 at 3:40 PM, Thomas Poty <thomas.poty@gmail.com> wrote:
Actually, We are migrating from Mysql to postgresql and we have to replace sets of Mysql. The migration we will be done in 2 steps: First, in a like for like way. Second step will be using postgresql powerfulnessI think the most like for like way to migrate sets is using enum array.Thank you Andreas.ThomasLe 22 déc. 2017 20:22, "Andreas Kretschmer" <andreas@a-kretschmer.de> a écrit :On 22 December 2017 20:02:43 CET, Thomas Poty <thomas.poty@gmail.com> wrote:
>Hello all,
>
>I use postgresql 9.5 and I am looking for way to have a column which is
>an
>array of a foreign key. If what I read is correct it is currently not
>possible... Have you any idea how to implement this feature in a safe
>way
Normalisation?
Can you explain that a bit more, what's the use-case?
Regards, Andreas
--
2ndQuadrant - The PostgreSQL Support Company
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.
--
Melvin Davidson
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
pgsql-general by date: