Re: Problem between inheritance and references

On Tue, 23 Jul 2002, Stephane Bortzmeyer wrote:

> I'm just beginning with inheritance and I have problems using
> REFERENCES integrity constraints to an inherited table. The schema is
> attached. When I try the second INSERT, I get:
>
> psql:./auth.sql:22: ERROR:  <unnamed> referential integrity violation
> - key referenced from users not found in authentication
>
> But the key does exist:

The problem is that foreign keys, primary keys, unique constraints,
and triggers (and maybe other stuff, but at least that) don't inherit,
so the foreign key is referencing only the table mentioned.  The
equivalent select is select * from ONLY Authentication I believe.