Timeline for PostgreSQL most efficient way to reference multiple tables
Current License: CC BY-SA 4.0
3 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Dec 19, 2018 at 8:00 | comment | added | Guiik | I thought it would be easier to discuss an example table, since both you and @a_horse_with_no_name asked for it, I will provide the real data as soon as I can. | |
| Dec 19, 2018 at 7:59 | comment | added | Guiik | What you are describing is my third solution with a table that holds a primary key that is referenced by the other tables. Yes, what I meant by inheritance was PostgreSQL's "table inheritance", which doesn't work when you want to reference an inherited column (as explained in postgresql.org/docs/current/ddl-inherit.html 5.9.1 Caveats), I didn't know it was PostgreSQL specific. | |
| Dec 18, 2018 at 23:26 | history | answered | Neil McGuigan | CC BY-SA 4.0 |