Re: [HACKERS] create index regression fail

2012-01-12 Thread Alvaro Herrera
Excerpts from Jaime Casanova's message of jue ene 12 16:22:17 -0300 2012: > On Thu, Jan 12, 2012 at 1:59 PM, Tom Lane wrote: > > Jaime Casanova writes: > >> the query where the regression fails is: > > > >> SELECT count(*) FROM dupindexcols > >>   WHERE f1 > 'LX' and id < 1000 and f1 ~<~ 'YX'; >

Re: [HACKERS] create index regression fail

2012-01-12 Thread Jaime Casanova
On Thu, Jan 12, 2012 at 1:59 PM, Tom Lane wrote: > Jaime Casanova writes: >> the query where the regression fails is: > >> SELECT count(*) FROM dupindexcols >>   WHERE f1 > 'LX' and id < 1000 and f1 ~<~ 'YX'; > >> my first theory was that it was because some locale because mine is >> es_EC.UTF-8

Re: [HACKERS] create index regression fail

2012-01-12 Thread Tom Lane
Jaime Casanova writes: > the query where the regression fails is: > SELECT count(*) FROM dupindexcols > WHERE f1 > 'LX' and id < 1000 and f1 ~<~ 'YX'; > my first theory was that it was because some locale because mine is > es_EC.UTF-8 but the content of the table doesn't justify that, [ exper

[HACKERS] create index regression fail

2012-01-12 Thread Jaime Casanova
Hi, In current HEAD, create index regression is failing (at least here). Is anyone else seeing this? Attached regression.diffs the query where the regression fails is: SELECT count(*) FROM dupindexcols WHERE f1 > 'LX' and id < 1000 and f1 ~<~ 'YX'; my first theory was that it was because some