Re: [BUGS] BUG #5705: btree_gist: Index on inet changes query result

2011-03-05 Thread Bruce Momjian
This is currently a TODO so at least we are tracking it. --- andreas wrote: > On Tue, 2010-10-19 at 18:22 -0400, Tom Lane wrote: > > Robert Haas writes: > > > On Mon, Oct 11, 2010 at 7:50 PM, Tom Lane wrote: > > >> Well, a

Re: [BUGS] BUG #5705: btree_gist: Index on inet changes query result

2011-02-25 Thread Bruce Momjian
Teodor, would you please comment on this bug after reading the entire thread which includes comments from other developers? http://archives.postgresql.org/pgsql-bugs/2010-10/msg00099.php Thanks. --- Andreas Karlsso

Re: [BUGS] BUG #5705: btree_gist: Index on inet changes query result

2010-10-21 Thread andreas
On Tue, 2010-10-19 at 18:22 -0400, Tom Lane wrote: > Robert Haas writes: > > On Mon, Oct 11, 2010 at 7:50 PM, Tom Lane wrote: > >> Well, actually the btree_gist implementation for inet is a completely > >> broken piece of junk: it thinks that convert_network_to_scalar is 100% > >> trustworthy and

Re: [BUGS] BUG #5705: btree_gist: Index on inet changes query result

2010-10-19 Thread Tom Lane
Robert Haas writes: > On Mon, Oct 11, 2010 at 7:50 PM, Tom Lane wrote: >> Well, actually the btree_gist implementation for inet is a completely >> broken piece of junk: it thinks that convert_network_to_scalar is 100% >> trustworthy and can be used as a substitute for the real comparison >> funct

Re: [BUGS] BUG #5705: btree_gist: Index on inet changes query result

2010-10-19 Thread Robert Haas
On Mon, Oct 11, 2010 at 7:50 PM, Tom Lane wrote: > "Andreas Karlsson" writes: >> I was looking at the code to see how one would improve indexing of the inet >> types and saw an inconsistency between the compressed format >> (gbt_inet_compress) and how network_cmp_internal works. The btree_gist >>

Re: [BUGS] BUG #5705: btree_gist: Index on inet changes query result

2010-10-11 Thread Tom Lane
"Andreas Karlsson" writes: > I was looking at the code to see how one would improve indexing of the inet > types and saw an inconsistency between the compressed format > (gbt_inet_compress) and how network_cmp_internal works. The btree_gist > module ignores the netmask. Well, actually the btree_g

[BUGS] BUG #5705: btree_gist: Index on inet changes query result

2010-10-11 Thread Andreas Karlsson
The following bug has been logged online: Bug reference: 5705 Logged by: Andreas Karlsson Email address: andr...@proxel.se PostgreSQL version: 9.1 Operating system: Linux Description:btree_gist: Index on inet changes query result Details: Hi, I was looking at the c