Inherited tables and foreign keys

From: Eva Hovelsrød <ehovelsrod(at)itsopen(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Inherited tables and foreign keys
Date: 2004-03-04 14:17:35
Message-ID: 200403041517.35555.ehovelsrod@itsopen.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-general by date

  From Date Subject
Next Message Karl O. Pinc 2004-03-04 14:26:44 Re: REFERENCES error message complaint, suggestion
Previous Message Marc G. Fournier 2004-03-04 14:04:07 Re: META: Filtering viruses/worms