On 17/01/2017 11:59, Dimitry Sibiryakov wrote: >> A classical example: isql -x >> >> Creates lots of workarounds and many times has problems with >> dependencies, while it could instead create all metadata in the same >> transaction without care about order and commit everything together >> letting the engine do the job. > Yes, that's exactly what I was talking about: dependency on objects that > don't exist > yet. Should work perfectly well using deferred FK constraints on system > tables. > Currently system tables don't have foreign keys at all and dependency > checking is done > by code. Changing that can make code simpler and robust. > > Temporary invalidated state is incompatible with DDL+DML using the being-changed DDL:
create table t (n integer, c computed by (f(n))); -- create function f ... commit; ---- drop function f; select * from t; -- ?? Adriano ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, SlashDot.org! http://sdm.link/slashdot Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel