2012/7/11 Tom Lane <t...@sss.pgh.pa.us>: > Emanuel Calvo <postgres....@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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
