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

From: "John Hansen" <john(at)geeknet(dot)com(dot)au>
To: "Steve Atkins" <steve(at)blighty(dot)com>, "pgsql-hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [BUGS] Bug in create operator and/or initdb
Date: 2005-01-30 10:31:12
Message-ID: 5066E5A966339E42AA04BA10BA706AE56242@rodrick.geeknet.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> 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.)

Yes, which is actually what brought this to my attention.
I'll be sending an rtree index implementation shortly for review/comments.

> 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?

I wouldn't think so, anyone I've spoken with has come up with other ways of managing that kind of info, because of, as you mentioned, it's lack of proper index methods.

Kind Regards,

John Hansen

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message John Hansen 2005-01-30 10:34:40 Rtree index method for inet/cidr
Previous Message Nicolai Tufar 2005-01-30 10:17:35 Repleacement for src/port/snprintf.c