Re: Key not present in table, but it is. - Mailing list pgsql-general

Emanuel Calvo <postgres.arg@gmail.com> writes:
> Executed the following statement:
> ...
> ERROR:  insert or update on table "veraz" violates foreign key
> constraint "veraz_dni_fkey"
> DETAIL:  Key (dni)=(21530976) is not present in table "persona".

>  But the record is present:

> coches=# select * from dia4.persona where dni = 21530976;

The record is present in a child table of dia4.persona, not dia4.persona
itself (try "SELECT ... FROM ONLY dia4.persona" to confirm this).
Foreign key constraints do not look into child tables; see the Caveats
section at the bottom of
http://www.postgresql.org/docs/9.1/static/ddl-inherit.html

            regards, tom lane