Subject RE: [firebird-support] Why IN AUTONOMOUS TRANSACTION doesnt work here?
Author Leyne, Sean


It is as expected, data type constraints are enforced before all other operations.


What would be the purpose of firing a trigger if the data is not valid?





From: [] On Behalf Of W O
Sent: Thursday, September 19, 2013 12:00 PM
Subject: Re: [firebird-support] Why IN AUTONOMOUS TRANSACTION doesnt work here?


That's right, the trigger never fires when the column is VARCHAR(20) and the lenght of data is greater than 20.


Is that a bug or it works as expected?







On Thu, Sep 19, 2013 at 10:28 AM, Mark Rotteveel <mark@...> wrote:


On 19-9-2013 15:58, Alan McDonald wrote:
> Use an external table to log errors. They are not subject to
> transactions.

But if the trigger doesn't fire, that won't help.

Mark Rotteveel