Re: Indexes not working, please help.

    Antonis,

    That was not the case, it appears that PostgreSQL have problems
matching the type on the table and on the queries. For instance, cod is a
bigserial primary key, so it does has a index but when you query it
without specifying ::bigint after the value, I don't know why, PostgreSQL
won't use it's indexes.

    With the "serial" type it works perfectly.

    Thanks anyway,

    Ricardo.

On Fri, 5 Jul 2002, Antonis Antoniou wrote:

> Hi,
> Is your index on the attribute cod? If not then try this:
> CREATE INDEX teste ON medidas (cod);
>
> Thanks
> Antonis