4 ms·
That would be interesting - but I wonder if it makes sense. @btilly: what is the name of the thing with locking queries you referred to?
by just_hobbyst 13y ago
That would be interesting - but I wonder if it makes sense.
@btilly: what is the name of the thing with locking queries you referred to?
- btilly 13y agoAny upgrade script that does certain operations will lock tables as it goes. See your database documentation for details. This can include rebuilding indexes, removing columns, modifying existing columns, etc. Furthermore when you've got both stored procedures and tables changing, you have to get the order of operations correct. I'm not aware of any automated tool that can figure out the dependencies and do so correctly. (Mind you I have not looked recently.)