Claudio,

without the new Firebird type, how can I recognize CHECK triggers for WITH
CHECK OPTION views? I can't figure it out... They don't appear in
RDB$CHECK_CONSTRAINTS and I cannot find them anywhere...

And I can't remember what the RDB$FLAGS column in RDB$TRIGGERS does either
-- pfff...

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com

> > 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.

[Non-text portions of this message have been removed]