Hello list,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! --- |
- [GENERAL] alter column to varchar without view drop/re-creat... Emi Lu
- Re: [GENERAL] alter column to varchar without view drop... Emi Lu