Virgil Frum wrote:
If column type is int4 and try to change type to int2, SQL look like this:
UPDATE pg_attribute
SET atttypid=, atttypmod=-1
WHERE attrelid=21459::oid AND attnum=3;
and syntax error occurs. I know that int2 is not in Data type drop down list
but error should be avoided in some way.
Well don't do that :-)
Seriously: fixed and committed to cvs.
Regards,
Andreas
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings