3799564 - ALTER script generates DROP/CREATE for decimal-to-bigint column type change instead of ALTER COLUMN - SAP PD

• When a column's data type is changed from a decimal type (e.g. decimal(6,5)) to bigint, the Alter script generates DROP/CREATE instead of ALTER TABLE ... ALTER COLUMN ... SET DATA TYPE.
• The USING clause is the PostgreSQL-native mechanism for handling type changes where no implicit cast exists.  

• SAP PowerDesigner (PD) 16.7
• PostgreSQL 14.x

powerdesigner, postgresql, psql, alter, using, round, cast, floor, trim, datatype, numeric, decimal, bigint, smallint, integer, string, SAPEAD-6594, SAPEAD, 6594 , KBA , BC-SYB-PD , PowerDesigner , Known Error