Thanks for the clarification Teodor - it makes much more sense now.
I'd agree the error message is confusing, particularly since this works:
set enable_seqscan to on;
set enable_indexscan to off;
set enable_bitmapscan to off;
select *
from test.features
where to_tsquery('') @@ features.vector;
Hi Tom,
Thanks for the quick reply.
>> Sorry, mistyped the query causing the problem. It is:
>
>> select *
>> from maps, features
>> where maps.query @@ features.tags_vector;
>
> In that case it's fair to ask what query values you have stored in maps.
> In particular I imagine that you'll find
Sorry, mistyped the query causing the problem. It is:
select *
from maps, features
where maps.query @@ features.tags_vector;
Thanks,
Charlie
Charlie Savage wrote:
I've run across another GIN index issue - using postgresql 8.1.4 on
Window/Linux with the GIN/tsearch2 patch.
I hav
I've run across another GIN index issue - using postgresql 8.1.4 on
Window/Linux with the GIN/tsearch2 patch.
I have two tables like this:
CREATE TABLE maps
(
id serial,
query tsearch2.tsquery
)
CREATE TABLE features
(
id serial,
vector tsearch2.tsvector
)
CREATE INDEX idx_features_t
