I am working on updating a database and have found that I am missing many rows from one of my tables. If you look at the attached picture below, you can see some of the missing rows. The far left is a sequential unique identifier and each of the rows on the right is a foreign key linked to other tables (including an userid column). These foreign keys have an "ON DELETE CASCADE" definition as well. I am using pg_prepare and pg_query to send my information to the database. Do I need to 'begin' and 'commit' these? Where should I look to debug this problem? Basically, any advice or experience with this type of problem?
Aucun commentaire:
Enregistrer un commentaire