Yes, I know that; but even when I reload it, copy complains it can't
convert 194.250.190.185 ( for example) to inet!
Regards
On Fri, 2 Jun 2000, Alex Pilosov wrote:
> 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
> >
> >
>
--
Olivier PRENANT Tel: +33-5-61-50-97-00 (Work)
Quartier d'Harraud Turrou +33-5-61-50-97-01 (Fax)
31190 AUTERIVE +33-6-07-63-80-64 (GSM)
FRANCE Email: ohp@pyrenet.fr
------------------------------------------------------------------------------
Make your life a dream, make your dream a reality. (St Exupery)