"Martijn Tonies" <martijn@...> wrote in message
news:C1FE56B5C29FD211A99F00A0244BE8200CF837@SRV_BISIT...

> Hi all,
>
> I have a database on IB 6.0.2 and created a view with the WITH CHECK

OPTION

> clause. I noticed appearing two triggers, obviously checking the clause :)
>
> When I did the same yesterday on IB 6.5, these triggers didn't appear as
> 'normal' triggers, but had a RDB$SYSTEM_FLAG value of 5 (VIEW CHECK

OPTION).

> IB 6.0.2 doesn't know this type in RDB$TYPES.
>
> FB RC2 restored the database with the two 'normal' triggers. Dropping the
> view and re-creating it created the two triggers with type 5 - is this one
> of the bugfixes for FB and taken into IB 6.5?

Please double check which engine you used. :-)
I wasn't aware that IB6.5 would do the same than Firebird. Hope you really
ran the IB6.5 executable. I assigned numbers to the special triggers to
avoid supposing things based on names like CHECK_ and INTEG_ because you can
create those names with normal DDL. However, for compatibilty, we still
check names.

C.
--
Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
Independent developer
Owner of the Interbase® WebRing