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

2012/7/11 Tom Lane : > Emanuel Calvo 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

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

Emanuel Calvo 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 wh