<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