index error - Mailing list pgsql-bugs

From Hao He
Subject index error
Date
Msg-id 686B9E7C8AA57A45AE8DDCC5A81596AB14CB47@sydthqems01.INT.TISA.COM.AU
Whole thread Raw
Responses Re: index error  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List 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

pgsql-bugs by date:

Previous
From: pgsql-bugs@postgresql.org
Date:
Subject: Bug #530: index does not work on int8
Next
From: jacques.talbot@muhc.mcgill.ca
Date:
Subject: Error linking on aix with-tcl