Re: BUG #12126: Empty tsvector as output of to_tsvector function

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: marcin(dot)ogorzalek(at)jmkcomputerate(dot)pl
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #12126: Empty tsvector as output of to_tsvector function
Date: 2014-12-02 17:18:08
Message-ID: 4699.1417540688@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

marcin(dot)ogorzalek(at)jmkcomputerate(dot)pl writes:
> I was trying to use postgresql full text search feature but all texts used
> were giving me empty tsvectors as a returned value therefore being
> unusable.

> I even tested part of your own documentation as stated below and it gave me
> empty result as well. I'm pretty sure that returned ts_vector was not over
> 1MB and there were no warnings or errors. Postgres states that it
> successfully returned 1 row.

The example works for me; I get

'10':190,675 '11.7':304 '12.2':1 '12.2.1':30 '12.2.2':249 '12.4.3':705 '12.9':259 '2':280,388 'ad':236 'ad-hoc':235 'add':604 'affect':322 'allow':487 'also':81 'alter':601 'altern':118 'although':215 'anoth':460,560 'anytim':699 'appl
ic':224 'approach':228,561 'argument':281,370,389 'b':411,422,541 'bodi':63,74,132,169,178,276,409,420,475,539,559,584,622,702 'call':198 'cannot':423 'chang':703 'clariti':192 'coalesc':196,586,619,621 'col':608,615,644,663 'collect':5
13 'column':461,481,546,568,605,680,697 'complex':150,450 'concaten':545,580 'config':147,318,473,477,537 'configur':107,123,141,295,342,397,436,455,489,497 'constant':17 'contain':57,161,207,333,514 'content':310,325 'correct':365 'cou
ld':120,332 'creat':162,181,246,250,254,265,337,439,463,547,564,625,634,666,690 'current':698 'data':26 'date':187,672 'default':144,315 'desc':188,673 'differ':330,339,517 'document':159,512,515 'dump':359 'e.g':462,533 'english':73,77
,106,275,408,557,618 'ensur':425,588 'entri':331,442,503 'even':544 'exampl':6,151,509,577 'except':231 'explain':706 'express':301,451 'fast':652 'field':64,214,591 'find':82,204,226 'friend':60,78,87,89,135 'full':12,40,653 'function'
:197,291 'gin':256,272,470,554,627,641 'guess':350 'hoc':237 'hold':570 'idx':268,466,550,637 'illustr':11 'imposs':357 'inconsist':328 'index':4,29,45,222,248,251,257,266,302,309,324,364,379,402,415,428,441,452,464,493,502,527,542,548,
595,607,614,628,635,643,662 'keep':694 'languag':518 'last':185,670 'lexem':99 'limit':189,674 'match':14,532 'meant':523 'might':326 'mix':488 'mod':186,671 'must':311,528 'name':296,398,456,474,478,538 'necessari':688 'need':202 'norm
al':98,115 'notic':277 'null':208,600 'occasion':234 'omit':121,194 'one':210,590 'option':27 'order':183,668 'output':572 'paramet':124 'pars':113 'perform':650 'perhap':232 'pgweb':69,128,173,267,270,465,468,484,549,552,603,611,639,65
9 'phrase':530 'possibl':36,445 'practic':239 'previous':9 'print':50 'queri':48,101,137,217,383,520 'readi':648 'recent':158 'record':495 'reduc':94 'refer':384 'relat':83 'represent':685 'requir':245 'restor':361 'row':55,205 'search'
:24,31,42,146,238,243,264,290,317,341,633,655 'section':10,20,258,303,704 'select':66,125,154,170,656 'separ':566,679 'set':142,447,612 'show':21 'simpl':16,47 'sinc':90 'slow':230 'specifi':103,293,458 'speed':261,630 'still':593 'stor
e':682 'string':18,117 'tabl':2,25,33,164,182,485,602,667 'ten':156 'text':13,41,145,242,263,289,316,340,654 'textsearch':606,613,636,642,661 'titl':52,67,126,167,171,177,558,582,620,657,700 'trigger':692 'tsqueri':76,134,180,665 'tsvec
tor':72,131,176,274,285,334,374,393,407,419,472,536,556,567,575,609,617,684,696 'two':213,369 'two-argu':368 'unaffect':313 'updat':610 'use':15,28,111,139,240,271,287,299,376,386,400,413,431,437,469,499,507,525,553,585,640,677 'usual':
244 'version':282,371,390 'way':348 'wherein':453 'without':43,220 'word':59,84 'work':219 'would':200,345,355,505

What have you got default_text_search_config set to? Have you changed
any of the files within the installation directory's share/tsearch_data/
subdirectory?

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Marcin Ogorzałek 2014-12-02 19:45:40 Re: BUG #12126: Empty tsvector as output of to_tsvector function
Previous Message eshkinkot 2014-12-02 13:17:02 BUG #12128: Cannot start backup again if it shutdown after replay one *.history file.