On 02/09/2015 01:12 PM, Andreas Joseph Krogh wrote:
> Are there any ways around this or do people simply avoid having FKs in
> schemas like this?
Don't use EAV. It's a bad design pattern, especially for you, and
you've just discovered one of the reasons why.
(In fact, I am just today dismantling an EAV database and normalizing
it, and so far application throughput is up 500%)
--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com