| From: | Ertan Küçükoğlu <ertan(dot)kucukoglu(at)1nar(dot)com(dot)tr> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Change column type macaddr to macaddr[] |
| Date: | 2017-12-30 23:53:43 |
| Message-ID: | 002401d381c9$6cde3d70$469ab850$@1nar.com.tr |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hello,
I am using PostgreSQL 9.6.6 on armv8l-unknown-linux-gnueabihf, compiled by
gcc (Raspbian 6.3.0-18+rpi1) 6.3.0 20170516, 32-bit
I have a table with column name mac type macaddr. I need to change it into
array of macaddr ( macaddr[] ) type. Among all others I did try below:
licenses=# alter table licreqm alter column mac type macaddr[] using
mac::macaddr[];
ERROR: cannot cast type macaddr to macaddr[]
LINE 1: ... licreqm alter column mac type macaddr[] using mac::macaddr[...
^
I believe there should be a way, I just do not know it myself. Anyone can
help me?
Thanks & regards,
Ertan Küçükoğlu
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2017-12-30 23:56:13 | Re: Change column type macaddr to macaddr[] |
| Previous Message | Stephen Frost | 2017-12-30 23:49:31 | Re: Sv: Re: Does PostgreSQL check database integrity at startup? |