Error when changing column type - Mailing list pgadmin-support

From Virgil Frum
Subject Error when changing column type
Date
Msg-id 003301c4c1d3$7c34ecc0$310210ac@virgil
Whole thread Raw
Responses Re: Error when changing column type
List pgadmin-support
If column type is int4 and try to change type to int2, SQL look like this:

UPDATE pg_attribute  SET atttypid=, atttypmod=-1WHERE 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



pgadmin-support by date:

Previous
From: Andreas Pflug
Date:
Subject: Re: PGADMIN III
Next
From: Andreas Pflug
Date:
Subject: Re: Error when changing column type