Re: macaddr 64 bit (EUI-64) datatype support - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: macaddr 64 bit (EUI-64) datatype support
Date
Msg-id 20161018232521.GB11661@momjian.us
Whole thread Raw
In response to Re: macaddr 64 bit (EUI-64) datatype support  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: macaddr 64 bit (EUI-64) datatype support  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
On Wed, Oct 12, 2016 at 08:33:00AM -0400, Tom Lane wrote:
> As others have noted, there is no likelihood that we'd take a disk-format-
> compatibility-breaking patch for v10.  Even if we wanted to do that, the
> above proposal would also break send/recv (binary COPY) compatibility for
> macaddr.
> 
> I think that probably the best bet here is to have two types and put some
> thought into making them interoperate where appropriate, as the various
> sizes of int do.  It's kind of a shame that this won't look like the
> approach used for inet addresses, but we're stuck.

If feels like we are going into VARCHAR2 territory where we end up
telling people to use an oddly-named data type forever.  Some are
suggesting JSONB is in that category.

I wish I had a suggestion, but I am not above adding trickery to
pg_upgrade to improve the outcome.

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com

+ As you are, so once was I.  As I am, so you will be. +
+                      Ancient Roman grave inscription +



pgsql-hackers by date:

Previous
From: Claudio Freire
Date:
Subject: Re: Indirect indexes
Next
From: Amit Kapila
Date:
Subject: Re: Hash Indexes