-1

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?

irvandi
  • 1
  • 2

1 Answers1

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.

Umut TEKİN
  • 856
  • 1
  • 9
  • 19