You cannot change column type without dropping/recreating the table.
On Fri, 2 Jun 2000, Olivier PRENANT wrote:
> Hi all,
>
> I've had a table for years to keep radius connections to our NAS.
>
> Not havin inet type, I typed ip_adress as text. Now, I'em trying to change
> this column type to no avail.
>
> select inet(ip_addr)... : cannot cast type to inet
>
> How can I change this column??
>
> TIA
>
>