Subject | Re: serious bug |
---|---|
Author | tomsee7 |
Post date | 2010-07-07T12:27:15Z |
This is not a 'serious bug', this is safety - paramount in databases.
Some changes to domains are relatively harmless whereas others can be very serious indeed.
> Why can't you edit domains if they are used in a foreign key constraint?To protect against data corruption?
Some changes to domains are relatively harmless whereas others can be very serious indeed.
--- In firebird-support@yahoogroups.com, "sqlsvr" <sqlsvr@...> wrote:
>
> Why can't you edit domains if they are used in a foreign key constraint? What kind of nonsense is that?
>
> If you have a natural key that is used in many places and the datatype ever or rule ever change (and they do in real business systems), you have to manually drop/recreate every constraint that refers to the domain in Firebird. How can Firebird call itself a relational DBMS when it fails to support domains properly?!?!?!?!?
>