On Fri, Jun 28, 2013 at 8:45 AM, David Greco <David_Greco@xxxxxxxxxxxxxxx> wrote:
The last delete statement will throw a referential integrity error. In Oracle, same example, it does not as the trigger deletes the child.
Not sure your real case, but why not just make the FK on delete cascade and get rid of your trigger entirely?
Alternatively, what if you make your constratint initially deferred?
