Recently I discovered a coding error of mine in a trigger that is called only for deletes.
I was returning NEW instead of OLD. Since NEW is undefined when deleting a row, it was failing and the row wasn't being deleted. However, it was failing silently. Shouldn't this have recorded an error or warning somewhere? -- Mike Nolan
