Excerpts from Casey Havenor's message of mié jun 29 14:24:11 -0400 2011: > Problem: > > I like many other have come across the inherit issues. > > I found the thread here about such issue... > http://postgresql.1045698.n5.nabble.com/FK-s-to-refer-to-rows-in-inheritance-child-td3287684.html > > > I grabbed the "fk_inheritance.v1.patch" file and have been trying to install > it for the last two hours.
I suggest you do not run a patched version of Postgres. The reason this patch hasn't been included is that it doesn't completely solve the problem, it might cause others because it hasn't been fully tested, and to make matters worse, you are on your own if you run a system with it because we cannot support you if you have weird problems. Particularly so if you're new to Postgres. Doubly so if you're new to patching source code. My advice would be to use some other design that does not involve FKs on inheritance hierarchies. (Yes, partitioning becomes a hard problem). -- Álvaro Herrera <alvhe...@commandprompt.com> The PostgreSQL Company - Command Prompt, Inc. PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
