Any workarounds for lack of primary key on partitioned tables?
2
votes
1
answer
1115
views
I am currently looking at implementing declarative partitioning with PostgreSQL 10. However, one sticking point is that we need to have a foreign key between two such partitioned tables, which is not supported. Is there any workaround or suggestions for alternative ways of doing this anyone can suggest? Or should we use table inheritance instead.
Thanks.
Asked by J. Gallagher
(29 rep)
Jul 12, 2018, 09:17 AM
Last activity: Apr 26, 2025, 03:09 PM
Last activity: Apr 26, 2025, 03:09 PM