how to alter length of a table column used in views

Question

i want to change length of a table column of postgresql database table. this is the error :

ERROR: cannot alter type of a column used by a view or rule
DETAIL: rule _RETURN on view av_viewname depends on column "orderref

is there way to to change column length without destroy views?

Please use plain text in this topic instead of an image somewhere else — Frank Heikens, Jul 20 '22 at 16:23

score 0 · Answer 1 · answered Jul 21 '22 at 14:10

0

Please check this topic and then proceed for your alteration.

You cannot change your columns' size without dropping it. Yet, first you have to get the definition of your view.

answered Jul 21 '22 at 14:10

Umut TEKİN

1 Answers1