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.

Reply via email to