Error when changing column type

From: "Virgil Frum" <virgil(at)livius(dot)net>
To: <pgadmin-support(at)postgresql(dot)org>
Subject: Error when changing column type
Date: 2004-11-03 18:32:33
Message-ID: 003301c4c1d3$7c34ecc0$310210ac@virgil
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Andreas Pflug 2004-11-03 19:40:19 Re: Error when changing column type
Previous Message Andreas Pflug 2004-11-02 16:54:11 Re: Installing PgadminIII