dbTalk Databases Forums  

[BUGS] tsearch2 headline function fails to parse integer arguments

mailing.database.pgsql-bugs mailing.database.pgsql-bugs


Discuss [BUGS] tsearch2 headline function fails to parse integer arguments in the mailing.database.pgsql-bugs forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Tom Hebbron
 
Posts: n/a

Default [BUGS] tsearch2 headline function fails to parse integer arguments - 01-09-2005 , 03:32 AM






SELECT headline('some text to search',to_tsquery('text'),'StartSel=<b>,
StopSel=</b>, ShortWord=3')

On 8.0beta1 through 8.0rc3 this query fails with
ERROR: invalid input syntax for integer: "3"

The same is reported when using any of the argument in the option string
that take integers (MinWords and MaxWords)
e.g.

SELECT headline('some text to search',to_tsquery('text'),'StartSel=<b>,
StopSel=</b>, MaxWords=35, MinWords=15, ShortWord=3');

ERROR: invalid input syntax for integer: "35"

Using the bundled tsearch2 from PostgreSQL 7.4.3 the headline function works
as expected, and the above examples return without error.

There also seems to be a problem with the bug submission form on the
website - the wwwmaster.postgresql.org server that handles the POST data
doesn't respond - it appears to be down?



---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Reply With Quote
  #2  
Old   
Tom Lane
 
Posts: n/a

Default Re: [BUGS] tsearch2 headline function fails to parse integer arguments - 01-09-2005 , 03:06 PM






"Tom Hebbron" <postgresql.org (AT) hebbron (DOT) com> writes:
Quote:
SELECT headline('some text to search',to_tsquery('text'),'StartSel=<b>,
StopSel=</b>, ShortWord=3')

On 8.0beta1 through 8.0rc3 this query fails with
ERROR: invalid input syntax for integer: "3"
Thanks for the report. Patch applied.

Quote:
There also seems to be a problem with the bug submission form on the
website - the wwwmaster.postgresql.org server that handles the POST data
doesn't respond - it appears to be down?
Not my turf, but maybe someone on pgsql-www will know what's up.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.