BUG #14362: Postgres macaddr does not support EUI-64 8-byte MAC addresses
The following bug has been logged on the website:
Bug reference: 14362
Logged by: Tilo Sloboda
Email address: tilo.sloboda@gmail.com
PostgreSQL version: 9.2.6
Operating system: Ubuntu
Description:
We are seeing 8-byte MAC addresses live in the wild and Postgres keeps
throwing errors when trying to save records with 8-byte MACs.
According to the documentation even PG 9.6 does not support 8-byte MAC
addresses, which seems like a major shortcoming.
What is the plan for Postgres to support EUI-64 MACs?
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
tilo.sloboda@gmail.com writes:
What is the plan for Postgres to support EUI-64 MACs?
I know of nobody working on that. Feel free to submit a patch.
(I'm afraid it might be nontrivial to get the current datatype
to do anything about this, though, since it's hard-wired as 6 bytes
on-disk.)
regards, tom lane
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
thanks for the quick answer.
I'm not a contributor of the Postgres code base.
The EUI-64 has been around for a while now, and real-world data contains
such MAC addresses.
How useful is the current macaddr data type if it breaks with real world
input data - and in turn end-users apps?
It would be great it either the macaddr type would be extended, or an
additional type could be introduced which can handle both 48 and 64-bit
MACs.
best regards, Tilo
On 10/10/16 10:00 AM, Tom Lane wrote:
tilo.sloboda@gmail.com writes:
What is the plan for Postgres to support EUI-64 MACs?
I know of nobody working on that. Feel free to submit a patch.
(I'm afraid it might be nontrivial to get the current datatype
to do anything about this, though, since it's hard-wired as 6 bytes
on-disk.)regards, tom lane
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
On Tue, Oct 11, 2016 at 6:41 AM, Tilo Sloboda <tilo.sloboda@gmail.com> wrote:
I'm not a contributor of the Postgres code base.
And? Anybody can become one, including yourself:
https://wiki.postgresql.org/wiki/Submitting_a_Patch
Personally I have always a great time discussing, reviewing and
writing patches. There's always something new to look at. If you are
not willing to do the work but would like to get the feature in
Postgres core as fast as possible, your company could fund someone to
do this work, or just implement that as a external module. The latter
would be faster, but support is yours in the long term.
--
Michael
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs