You havn't posted the exact error message. You'll have to if you want
people to properly explain what's going on...
On Fri, Oct 08, 2004 at 04:07:43PM -0500, Josh Close wrote:
> 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
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.
