Re: [PgFoundry] Unsigned Data Types [1 of 2]

From: "Jaime Casanova" <jcasanov(at)systemguards(dot)com(dot)ec>
To: "Ryan Bradetich" <rbradetich(at)gmail(dot)com>
Cc: pgsql-patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: [PgFoundry] Unsigned Data Types [1 of 2]
Date: 2008-09-09 05:54:23
Message-ID: 3073cc9b0809082254g789a7f14x45e9d416925b1057@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

On Mon, Sep 8, 2008 at 10:08 PM, Ryan Bradetich <rbradetich(at)gmail(dot)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

Attachment Content-Type Size
uint_test1.sql text/x-sql 394 bytes
uint_test2.sql text/x-sql 405 bytes

In response to

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Ryan Bradetich 2008-09-09 06:25:31 Re: [PgFoundry] Unsigned Data Types [1 of 2]
Previous Message Ryan Bradetich 2008-09-09 03:08:12 Re: [PgFoundry] Unsigned Data Types [1 of 2]