tsearch2 headline function fails to parse integer arguments
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?
"Tom Hebbron" <postgresql.org@hebbron.com> writes:
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.
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
Tom Lane wrote:
"Tom Hebbron" <postgresql.org@hebbron.com> writes:
<snip>
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.
It seems to have been a temporary or intermittent problem. I just went
to the bug submission form at:
http://www.postgresql.org/support/submitbug
...and submitted a bug successfully. The "Thank you" page took a few
seconds to load than I was expecting (about 10 seconds in total), but
didn't time out.
If we get more reports of this, indicating its a continuing problem,
then we'll look into it. Otherwise, hopefully the failure was just a
once-off.
Thanks for letting us know guys.
Regards and best wishes,
Justin Clift
--
"One who sees the invisible can do the impossible."
+ Frank Gaines
-----Original Message-----
From: pgsql-www-owner@postgresql.org
[mailto:pgsql-www-owner@postgresql.org] On Behalf Of Tom Lane
Sent: 09 January 2005 21:04
To: Tom Hebbron
Cc: pgsql-bugs@postgresql.org; pgsql-www@postgresql.org
Subject: Re: [pgsql-www] [BUGS] tsearch2 headline function
fails to parse integer argumentsThere 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.
Hmm, odd:
root@developer:~# uptime
08:29:34 up 75 days, 23:56, 1 user, load average: 0.06, 0.02, 0.00
And there's nothing in my inbox about any net connection problems.
Regards, Dave.
Import Notes
Resolved by subject fallback
-----Original Message-----
From: pgsql-www-owner@postgresql.org
[mailto:pgsql-www-owner@postgresql.org] On Behalf Of Justin Clift
Sent: 10 January 2005 00:02
To: Tom Lane
Cc: Tom Hebbron; pgsql-bugs@postgresql.org; pgsql-www@postgresql.org
Subject: Re: [pgsql-www] [BUGS] tsearch2 headline function
fails to parseIf we get more reports of this, indicating its a continuing problem,
then we'll look into it. Otherwise, hopefully the failure was just a
once-off.
It's moving to a new host after release anyhoo...
/D
Import Notes
Resolved by subject fallback
Hi,
Dave Page wrote:
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.
Hmm, odd:
root@developer:~# uptime
08:29:34 up 75 days, 23:56, 1 user, load average: 0.06, 0.02, 0.00And there's nothing in my inbox about any net connection problems.
Well, I'm unable to connect to wwwmaster from home (traceroute stops
around the vale-housing gateway or something), but have no problems
connecting to it now from work...