[GENERAL] Delete cascade and trigger permissions?

I seem to have a problem accessing a temp table from a trigger when I use cascading deletes. I have 2 tables: a main table and a child table. The child table has a foreign key reference to the main table that has DELETE CASCADE on. I have delete triggers on both tables that are run BEFORE

Re: [GENERAL] Delete cascade and trigger permissions?

On Thu, Jul 06, 2006 at 02:06:46PM -0400, Brennan, Sean (IMS) wrote: All in the same db connection, I do the following: 1)create a temp table 2)delete rows from the main table 3)access the temp table in the delete trigger of the main table 4)access the temp table in the delete trigger of the