Error: Cannot alter size of column

[sarah]

Hello!

How do I fix this this error? I thought we could increase the size of a varchar column in a table?

Code: Select all

dbadmin=> ALTER table readers.book_digest ALTER COLUMN digest_desc SET DATA TYPE VARCHAR (100);
ROLLBACK 2353:  Cannot alter type of column "digest_desc" since it is referenced in the segmentation expression of projection "book_digest_b1"

[scutter]

You would need to create new projections that don't have this column in the segmentation expression, refresh them, drop the current projections that do have this column in the segmentation expression, alter the column, and then recreate your orignal progrections if that column really needs to be in the segmentation.

--Sharon

[sarah]

Thanks, scutter! I finally got time to look into this issue again and you were correct! I fixed it.