pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedBUG #17917: to_tsquery syntax error
3+ messages / 3 participants
[nested] [flat]
* BUG #17917: to_tsquery syntax error
@ 2023-05-03 10:01 PG Bug reporting form <noreply@postgresql.org>
0 siblings, 1 reply; 3+ messages in thread
From: PG Bug reporting form @ 2023-05-03 10:01 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org; +Cc: cyloz28@gmail.com
The following bug has been logged on the website:
Bug reference: 17917
Logged by: Cyrus Lozano
Email address: cyloz28@gmail.com
PostgreSQL version: 13.10
Operating system: Linux - Fedora 38
Description:
select to_tsquery('lowercase', plainto_tsquery('lowercase', 'test')::text ||
':*');
the above query runs successfully in Windows but got an error in Fedora 38:
ERROR: syntax error in tsquery: ":*"
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: BUG #17917: to_tsquery syntax error
@ 2023-05-03 13:46 Tom Lane <tgl@sss.pgh.pa.us>
parent: PG Bug reporting form <noreply@postgresql.org>
0 siblings, 1 reply; 3+ messages in thread
From: Tom Lane @ 2023-05-03 13:46 UTC (permalink / raw)
To: cyloz28@gmail.com; +Cc: pgsql-bugs@lists.postgresql.org
PG Bug reporting form <noreply@postgresql.org> writes:
> select to_tsquery('lowercase', plainto_tsquery('lowercase', 'test')::text ||
> ':*');
> the above query runs successfully in Windows but got an error in Fedora 38:
> ERROR: syntax error in tsquery: ":*"
Works for me, after substituting a text search configuration name that
I had installed:
=# select to_tsquery('english', plainto_tsquery('english', 'test')::text ||
':*');
to_tsquery
------------
'test':*
(1 row)
I think you mistyped something in the Fedora case. The error message
is pretty clear that what to_tsquery() got was only ':*'.
regards, tom lane
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: BUG #17917: to_tsquery syntax error
@ 2023-05-03 15:18 Cyrus Lozano <cyloz28@gmail.com>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 3+ messages in thread
From: Cyrus Lozano @ 2023-05-03 15:18 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-bugs@lists.postgresql.org
Hi Tom,
Thanks for checking. I did not notice that somehow, my flyway scripts related to the text search configuration failed, thus the error.
Please disregard this issue and apologies for the inconvenience.
Regards,
Cyrus Lozano
> On 3 May 2023, at 9:46 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> PG Bug reporting form <noreply@postgresql.org> writes:
>> select to_tsquery('lowercase', plainto_tsquery('lowercase', 'test')::text ||
>> ':*');
>
>> the above query runs successfully in Windows but got an error in Fedora 38:
>> ERROR: syntax error in tsquery: ":*"
>
> Works for me, after substituting a text search configuration name that
> I had installed:
>
> =# select to_tsquery('english', plainto_tsquery('english', 'test')::text ||
> ':*');
> to_tsquery
> ------------
> 'test':*
> (1 row)
>
> I think you mistyped something in the Fedora case. The error message
> is pretty clear that what to_tsquery() got was only ':*'.
>
> regards, tom lane
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2023-05-03 15:18 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-05-03 10:01 BUG #17917: to_tsquery syntax error PG Bug reporting form <noreply@postgresql.org>
2023-05-03 13:46 ` Tom Lane <tgl@sss.pgh.pa.us>
2023-05-03 15:18 ` Cyrus Lozano <cyloz28@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox