Postgres Pro
Downloads
Home   >   mailing lists

Re: Odd error message (" hash indexes do not support whole-index scans") - Mailing list pgsql-sql

From Tom Lane
Subject Re: Odd error message (" hash indexes do not support whole-index scans")
Date
Msg-id 1559.1114012954@sss.pgh.pa.us
Whole thread Raw
In response to Odd error message (" hash indexes do not support whole-index scans")  (Marinos Yannikos <mjy@geizhals.at>)
Responses Re: Odd error message (" hash indexes do not support whole-index  (Marinos Yannikos <mjy@geizhals.at>)
List pgsql-sql
Tree view 
Marinos Yannikos <mjy@geizhals.at> 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

pgsql-sql by date:

Previous
From: Marinos Yannikos
Date:
Subject: Odd error message (" hash indexes do not support whole-index scans")
Next
From: Stéphane RIFF
Date:
Subject: Query question