Re: BUG #12126: Empty tsvector as output of to_tsvector function - Mailing list pgsql-bugs

marcin.ogorzalek@jmkcomputerate.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