Thread: Inherited tables and foreign keys

Inherited tables and foreign keys

From
Eva Hovelsrød
Date:
Hi, I just realized that foreign keys to an inherited table don't work when
the record was inserted into a child table. That is postgresql-7.3.2-3.

Does anyone know whether anyone is working on that area or if there are any
plans to?

Or is there a simple workaround, like in the foreign key definition to say
that a column should reference the parent table OR the child table (i.e.,
providing a list of tables to look for references in)?

Best regards,

Eva Hovelsrod