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

W dniu 02.12.2014 18:18, Tom Lane napisał(a):
> 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


Thank You for quick response

After this message I've checked several things and problem was that
default_text_search_config set to pg_catalog.simple was unable to
recognize the text.
Only setting the regconfig parameter explicitly to 'english' gave the
results.

Regards Marcin Ogorzałek