Em 23/11/2016 12:37, Dimitry Sibiryakov escreveu: > 23.11.2016 14:54, Adriano dos Santos Fernandes wrote: >> But that (DDL changes with concurrent sessions) is unreliable. >> >> And if you change a single view that recompiles 100 views, you multiple >> the unreliability by 100 in the production environment. > That's why I, personally, prefer to prohibit altering anything that has > dependencies. > It works well for data with foreign key, it should work for metadata as well. > >
The ability to change a datatype without the need to drop everything that depends on it is a very helpful feature, but It's only viable if it is safe. The way it's implemented today is unsafe, and I prefer a much bigger work to drop everything and recreate it after the modification, than a handfull one that leads to error on production. If it's a choice: 1) Easy way with no promise of safety 2) Hard way, but safe I will choose option 2 without any doubt ------------------------------------------------------------------------------ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
