On Fri, 03 Aug 2001 13:58:50 -0400, Jenna Klein wrote:
>Oh I don't think I've ever used it in deployment but I've got a small file
>that adds the cascades and another that removes them. This way
when I am
>working on the database I can wipe out the data quickly.
Jenna,
In the absense of R:Base providing the messages you want, I would
say get rid of your small files that create and delete the CASCADES
and create a single small file in their place, that has the DELETE
commands you need, first deleting the rows in the foreign key tables,
then deleting the rows in the primary key table. Run that new file to
wipe out the data quickly.
It seems to me it is more work for you to use the CASCADE feature.
Bill
