Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgadmin-support by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group