Skip site navigation (1) Skip section navigation (2)

Re: [BUGS] Bug in create operator and/or initdb

From: Steve Atkins <steve(at)blighty(dot)com>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [BUGS] Bug in create operator and/or initdb
Date: 2005-01-30 04:20:10
Message-ID: 20050130042010.GA17396@gp.word-to-the-wise.com (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-hackers
On Sat, Jan 29, 2005 at 10:07:30PM -0500, Tom Lane wrote:
> "John Hansen" <john(at)geeknet(dot)com(dot)au> writes:
> > In that case may I suggest fixing the catalog so network_* functions exists for both datatypes!
> 
> Redesigning the inet/cidr distinction is on the to-do list (though I'm
> afraid not very high on the list).  ISTM it should either be one type
> with a distinguishing bit in the runtime representation, or two types
> with no such bit needed.  Having both is a schizophrenic design.  It's
> led directly to bugs in the past, and I think there are still some
> corner cases that act oddly (see the archives).

From a network engineering point of view the inet type is utterly
bogus. I'm not aware of data of that type being needed or used in
any real application. Given that, the complexity that it causes
simply by existing seems too high a cost.

I suspect that the right thing to do is to kill the inet type
entirely, and replace it with a special case of cidr. (And possibly
then to kill cidr and replace it with something that can be indexed
more effectively.)

For a replacement type, how important is it that it be completely
compatible with the existing inet/cidr types? Is anyone actually using
inet types with a non-cidr mask?

Cheers,
  Steve

In response to

Responses

pgsql-hackers by date

Next:From: Kevin BrownDate: 2005-01-30 04:36:06
Subject: Re: IBM patent
Previous:From: Tom LaneDate: 2005-01-30 03:07:30
Subject: Re: Bug in create operator and/or initdb

pgsql-bugs by date

Next:From: Tom LaneDate: 2005-01-30 06:46:19
Subject: Re: [BUGS] Bug in create operator and/or initdb
Previous:From: Tom LaneDate: 2005-01-30 03:07:30
Subject: Re: Bug in create operator and/or initdb

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group