Re: COMMIT in a trigger?

From: Jonathan Gennick <gennick_at_worldnet.att.net>
Date: 9 Feb 1999 05:02:10 GMT
Message-ID: <36c06925.3617444@netnews.worldnet.att.net>

You can't do a COMMIT from a trigger. You would lose control over your transactions if you could do something like that. Consider that I could issue the following statement:

delete from customer;

The rules state that the delete is not permenant until I explicitely issue a commit command. Thus, the following two commands result in no records being deleted:

	delete from customer;
	rollback;

But what if there was a DELETE trigger that did a commit? Suddenly I would be unable to rollback my own transaction. That's not good. Hence, no COMMITs from triggers.

Jonathan

On 7 Feb 1999 18:06:20 +0100, mattias.meyer_at_t-online.de (mme) wrote:

>Does anybody know how I can do a COMMIT in a trigger or procedures
>called by a trigger???
>
Received on Mon Feb 08 1999 - 23:02:10 CST