Re: alter column to varchar without view drop/re-creation

<meta content="text/html; charset=ISO-8859-1"
      http-equiv="Content-Type">





      <meta http-equiv="content-type" content="text/html;
        charset=ISO-8859-1">
      Hello list,

      May I know is there a way to "alter column type to varchar"
      (previous is varchar(***)) without view drop/re-creation?

      Basically, looking for a way to change column without have to
      drop/re-create dependent views.

      varchar(***) to varchar and no date/numeric changes.


    I saw docs mention about: update pg_attribute. May I know:

    . will dependent views updated automatically or there might be
    potential problems?
    . If it's fine, will the following SQL enough to change column from
    varchar(***) to varchar?

      update pg_attribute set atttypmod =-1
      where  attrelid = 'oid' ;

    Thanks a lot!


      ---
      PostgreSQL 8.3.18 on x86_64