index error

From: Hao He <Hao(dot)He(at)thomson(dot)com(dot)au>
To: "'pgsql-bugs(at)postgresql(dot)org'" <pgsql-bugs(at)postgresql(dot)org>
Subject: index error
Date: 2001-12-06 00:13:01
Message-ID: 686B9E7C8AA57A45AE8DDCC5A81596AB14CB47@sydthqems01.INT.TISA.COM.AU
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

hi,

If you create a table with one of the columns defined as int8, then the
index created on this column does not work. When I use explain to see
the plan, it is always seq scan instead of index scan as one would expect.
Other types of columns work fine (int4, string ...).

Hao

Attachment Content-Type Size
InterScan_Disclaimer.txt text/plain 438 bytes

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message jayesh tank 2001-12-06 11:35:04 Fwd: Error while inserting long string in database table.
Previous Message pgsql-bugs 2001-12-06 00:11:33 Bug #530: index does not work on int8