On Thu, Sep 19, 2013 at 12:21 PM, Leyne, Sean <Sean@...> wrote:

 

 

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?

 

 

Sean

 

From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of W O
Sent: Thursday, September 19, 2013 12:00 PM
To: firebird-support@yahoogroups.com
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?

 

Greetings.

 

Walter.

 

 

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
--
Mark Rotteveel