>
>On Thu, Sep 19, 2013 at 12:21 PM, Leyne, Sean <<mailto: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?

At 05:51 a.m. 20/09/2013, W O wrote:

>Catching exceptions, maybe?

Maybe NOT! PSQL has exception handling built in. The default handler passes execution immediately to the final EXIT statement and returns the error to the client. Write your own exception handlers in triggers, SPs and block executes to get the exact behaviour you desire, including logging records to external tables that will survive rollback.


Helen Borrie, Support Consultant, IBPhoenix (Pacific)
Author of "The Firebird Book" and "The Firebird Book Second Edition"
http://www.firebird-books.net
__________________________________________________________________