Re: pg_get_triggerdef in pg_dump - Mailing list pgsql-hackers

> If that's what you need you can always change the system catalogs
> manually.  For CHAR(n) and VARCHAR(n) you change pg_attribute.atttypmod
> to (n+4).  For NUMERIC(n,m) it's something like (n<<16) + m + 4 or maybe
> (m<<16) + n + 4, don't remember right now.
>
> Be sure to check that your data is in a safe place before you do this,
> and double check before you commit the transaction if you do it
> manually.

Is there demand for an ALTER COLUMN/SET TYPE that is restricted to binary
compatible casts and increasing length changes?

Chris