2012/7/11 Tom Lane <tgl@sss.pgh.pa.us>:
> 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
Got it. I thought that was happening something like this, didn't
remember about that limitation.
Thanks you once again the help.
--
--
Emanuel Calvo