The Movie Database Support
Support → API Support
Referential integrity broken
posted by bklineSTAFFMOD on August 28, 2024 at 7:02 AM
Convince me that it's a good idea to allow deletion of Person records while there are still Movie records which depend on those Person records.
Reply by superboy97
on August 28, 2024 at 3:02 PM
The person will simply be removed from the movies.
Reply by bkline
on August 28, 2024 at 3:13 PM
That might happen eventually, but recently I've run into lots of errors where I ask the API for the credits for a movie, then I ask for the Person record for each actor or director identified in the credits response, and the software blows up because one of the Person records referenced in the credits response has disappeared. The reference to the Person record should be cleared from the Credits record BEFORE the Person record is deleted, not after.
Reply by superboy97
on August 28, 2024 at 3:16 PM
They are cleared at the same time.
What have certainely happen is that the movie query was already cached at that time.