| From: | Craig Ringer <ringerc(at)ringerc(dot)id(dot)au> |
|---|---|
| To: | Rafal Pietrak <rafal(at)zorro(dot)isa-geek(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: foreign key from array element |
| Date: | 2012-09-17 11:58:55 |
| Message-ID: | 5057107F.1030105@ringerc.id.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 09/17/2012 04:46 PM, Rafal Pietrak wrote:
> Hello the list,
>
> recently I'm cooking a database for an application, that I feel is best
> implemented with tables containing arrays.
>
> I have found some related info here:
> http://archives.postgresql.org/pgsql-hackers/2008-09/msg01356.php
>
> although the initial advice in that thread was: not to use arrays and:
> "learning database best practice".
>
> the thread eventually went into accepting this for implementation:
> http://archives.postgresql.org/pgsql-hackers/2008-09/msg01341.php
>
> Does anyone know if the implementation actually happened since? In which
> version? How does the syntax loook like?
There was some quite recent discussion on ELEMENT foreign keys on the
-hackers list. Try searching pgsql-hackers for ELEMENT foreign key.
See:
https://commitfest.postgresql.org/action/patch_view?id=775
https://commitfest.postgresql.org/action/patch_view?id=900
and the linked discussions.
--
Craig Ringer
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rafal Pietrak | 2012-09-17 12:24:03 | Re: foreign key from array element |
| Previous Message | Yvon Thoraval | 2012-09-17 11:52:23 | Re: On Ubuntu 12.04 i do have two psql one of those isn't working |