Inherited tables and foreign keys - Mailing list pgsql-general

From Eva Hovelsrød
Subject Inherited tables and foreign keys
Date
Msg-id 200403041517.35555.ehovelsrod@itsopen.net
Whole thread Raw
List pgsql-general
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

pgsql-general by date:

Previous
From: "Karl O. Pinc"
Date:
Subject: Re: REFERENCES error message complaint, suggestion
Next
From: "Karl O. Pinc"
Date:
Subject: Re: Moving from MySQL to PGSQL....some questions (multilevel