[Info-ingres] alter from nchar to char

[Karl and Betty Schendel]

Assuming that the alter is accepted, no.  It works just like an alter table
add column in that the old rows are coerced on the fly and new rows are
written with the new column definition.

A modify of the table will rewrite all the values but it logs as a regular
modify (i.e. a few log records, not one for each table row.)

Karl

> On May 18, 2018, at 5:29 PM, armand pirvu <armand.pirvu at gmail.com> wrote:
> 
> Hi  all
> 
> Does alter from nchar to char in a total table rewrite with massive logging ?
> 
> alter table irs.acb_cd_0216095833 alter column crd_logical_destination char(80) not null default ' ' \p\g
> 
> 
> Thanks
> — Armand
> _______________________________________________
> Info-ingres mailing list
> Info-ingres at lists.planetingres.org
> http://lists.planetingres.org/mailman/listinfo/info-ingres