| Subject | RE: [firebird-support] Why IN AUTONOMOUS TRANSACTION doesnt work here? |
|---|---|
| Author | Leyne, Sean |
| Post date | 2013-09-19T16:21:28Z |
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