I'm getting an error from within a stored procedure being called from
Coldfusion that is telling me that a foreign key value is not present in
the parent table, but it clearly is.
This happens infrequently, but seems to continue to happen despite
restarts.
Detailed message:
EXCEPTION MESSAGE: Error Executing Database Query.
DETAIL: [Macromedia][SequeLink JDBC Driver][ODBC Socket]ERROR: insert or
update on table "entity_documentation" violates foreign key constraint
"entity_documentation_distributor_id_fkey"
Key (distributor_id)=(87) is not present in table "distributors".;
Error while executing the query
NATIVEERRORCODE: 7
SQLSTATE: 23503
QUERYERROR: [Macromedia][SequeLink JDBC Driver][ODBC Socket]ERROR:
insert or update on table "entity_documentation" violates foreign key
constraint "entity_documentation_distributor_id_fkey"
Key (distributor_id)=(87) is not present in table "distributors".;
Error while executing the query
ERRORCODE: 23503
TIA!