Subject Re: [firebird-support] Re: Problem removing UDF
Author Milan Babuskov
kittikira wrote:
> I use Firebird
>>> Why does Firebird not tell me, that the udf is used by computed fields,
>>> when I want to drop it?
>>> If it is used in a stored procedure, a trigger or a view I cannot drop the
>>> UDF. Why can I drop it when it is used by a computed field?

I had a similar problem. Firebird version is not that important, ODS
version is. For example, I have two databases of the same logical
structure (SQL), but different on-disk structure (ODS). IIRC, on ODS
11.1 database the computed-field dependency was detected, and on 11.0
and below it was not (of something like that).

Check ODS version with gstat -h. If it is lower than 11.1, do a backup
and subsequent restore.


Milan Babuskov

The easiest way to import XML, CSV
and textual files into Firebird: