> 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 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
