It works for me for \copy (which uses inserts)
But yes, there is no way to convert text to inet, which is a pain. When it
annoys me sufficiently, I think I'll write text_inet wrapping inet_in...Or
just wait for someone else to do it (TODO, bruce? ;)
On Fri, 2 Jun 2000, Olivier PRENANT wrote:
> 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
> > >
> > >
> >
>
>