Emanuel Calvo <postgres.arg@xxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
