Re: [SQL] Odd error message (" hash indexes do not support whole-index scans")

2005-04-20 Thread Tom Lane
Marinos Yannikos <[EMAIL PROTECTED]> writes: > Shouldn't PostgreSQL behave in a different way in this case? (e.g. just > not use the index): Good catch. But why are you using a hash index for this? regards, tom lane ---(end of broadcast)-

[SQL] Odd error message (" hash indexes do not support whole-index scans")

2005-04-20 Thread Marinos Yannikos
Shouldn't PostgreSQL behave in a different way in this case? (e.g. just not use the index): Table "public.forum_messages" message_id | integer | not null default nextval('forum_messages_message_id_seq'::text) parent_userid