How can a delete rows from a table that has foreign key constraints? Here is how I have it set up.
I have 2 tables, tableA has fields and id's and tableB has fields that reference tableA's id's. I'm not able to do this BEGIN TRANSACTION; DELETE FROM tableB WHERE tableAid = 5; DELETE FROM tableA WHERE id = 5; COMMIT TRANSATION; Even though I delete everything from tableB that references tableA, I can't delete the field from tableA. Is this because of the begin and commit? Do I need to commit after each delete? The only problem with commiting after each is, if one fails for some reason, I need it to rollback. -Josh ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html