| Subject | WITH CHECK OPTION triggers |
|---|---|
| Author | Martijn Tonies |
| Post date | 2002-01-22T08:34:10Z |
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?
Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com
[Non-text portions of this message have been removed]
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?
Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com
[Non-text portions of this message have been removed]