Subject Re: [Firebird-Architect] Feature Request: Domains in SP & Triggers.
Author Daniel Rail
Hello Martijn,

Wednesday, October 13, 2004, 4:52:34 AM, you wrote:

>> You can change any constraint or default in the domain since it doesn't
>> affect the BASED ON declaration. However, you can't change the data type.
>> This will avoid the mismatches we are trying to prevent when one has to
>> maintain currently domains and procedure parameters in sync manually.
>> In the future, we could consider your request to invalidate objects.
>> BASED ON is accepted by GDEF and GPRE.

> So, changing the domain datatype is prohibited?

If I understand correctly, since the domain would be used in SPs and
triggers, and that at the present time they are not automatically
recompiled and/or invalidated, then it could cause problems if the
datatype of the domain would be changed.

So, this would mean that invalidate and/or recompile the dependant SPs
and triggers would have to be implemented to make the usage more
user-friendly. People are already complaining that if you change a
column's datatype that you have to either drop or empty the dependant
SPs and triggers in order to make the required datatype changes. So,
as you can see adding domain support in SPs and triggers, although
welcomed, yet it's still not user-friendly to manage.

Best regards,
Daniel Rail
Senior Software Developer
ACCRA Group Inc. (
ACCRA Med Software Inc. (