Re: [GENERAL] Changing column type from oid to int4

2004-12-02 Thread Tom Lane
Mario Weilguni <[EMAIL PROTECTED]> writes: > Did somebody ever try to change the type to a compatible type? I plan to > change a column from oid to int (once it holded a lob, now some sort of id) > with modifying pg_attribute: > update pg_attribute > set atttypid=(select oid from pg_type w

[GENERAL] Changing column type from oid to int4

2004-12-02 Thread Mario Weilguni
Did somebody ever try to change the type to a compatible type? I plan to change a column from oid to int (once it holded a lob, now some sort of id) with modifying pg_attribute: update pg_attribute set atttypid=(select oid from pg_type where typname='int4') where attname='whatever' and