I've a table with tsvector column named meta_vector. Over this column there
is a gin index. When I execute query like:
select id from theses where meta_vector @@@ to_tsquery('cs', 'foo | (!bar)')
I get an errror message: query requires full scan, which is not supported by
The weird thing is, that when I drop the index, or disable index scans, it
works. Why can't the planner just use full scans instead of index scans on
such the queries? Thanks for help.
View this message in context: http://www.nabble.com/-fulltext-Gin-index-full-scan-tp23482754p23482754.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
pgsql-general by date
|Next:||From: Cristina M||Date: 2009-05-11 14:31:19|
|Subject: Problem with estimating pages for a table|
|Previous:||From: Jasen Betts||Date: 2009-05-11 13:00:23|
|Subject: Re: Remote access|