Re: Key not present in table, but it is.

2012/7/11 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:
> Emanuel Calvo <postgres(dot)arg(at)gmail(dot)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