Alter Column from inet to inet[]

From: Alex - <aintokyo(at)hotmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Alter Column from inet to inet[]
Date: 2012-03-14 16:05:42
Message-ID: BAY170-W471EDAC618540FCB56CCC7CF590@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hi,I need to change a column type from inet to inet[] but the alter command always gives me the following errors
ERROR: column "access_ip" cannot be cast to type inet[]
ALTER TABLE users ALTER COLUMN access_ip SET DATA TYPE inet[] USING access_ip::inet[];
Tried various but no luck. Couldn't find anything in the manuals either.
Can anyone point me in the right direction or tell me what's wrong with my statement.
Thanks for any help.
Alex

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2012-03-14 16:16:58 Re: Alter Column from inet to inet[]
Previous Message Carson Gross 2012-03-14 16:02:15 Re: Upgrade questions