Thank you, David.
I should get more sleep...
Igal
On 7/31/2019 11:52 AM, David G. Johnston wrote:
On Wed, Jul 31, 2019 at 11:38 AM Igal @ Lucee.org <i...@lucee.org
<mailto:i...@lucee.org>> wrote:
alter table some_table
rename column amount_num to amount_text;
alter table some_table
drop column amount_num;
You just renamed amount_num to amount_text so I'm not sure why you
expect the drop to succeed.
Would it have less locking than simply altering the column?
I doubt anything will improve upon simply altering the column. You
have to perform a full table rewrite in either case which is going to
be the main resource consumer.
David J.