On Mon, Sep 8, 2008 at 10:08 PM, Ryan Bradetich <rbradetich@gmail.com> wrote:
>
> Can you send me the test case that generates this error?
> My regression tests do not include a table t1 so I was not able
> to reproduce this error directly.
>
yeah! that table is mine! here are the scripts...
> contrib_regression=# select f1 from t1 where f1 > 99998;
> f1
> --------
> 99999
> 100000
> (2 rows)
>
> My testing shows this is working correctly.
>
mmm... i rebuild my test env and it works for me this time... until i
execute an analyze. I guess autovacuum executed an auto analyze last
time...
--
regards,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. (593) 87171157