[pgadmin-support] Error when changing column type

[Virgil Frum]

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.

Regards,
Virgil


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faqs/FAQ.html