Re: Empty string in lexeme for tsvector

From: Jean-Christophe Arnu <jcarnu(at)gmail(dot)com>
To: Artur Zakirov <zaartur(at)gmail(dot)com>
Cc: Ranier Vilela <ranier(dot)vf(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Empty string in lexeme for tsvector
Date: 2021-09-27 10:18:00
Message-ID: CAHZmTm1MoTXXNN7yRwe+ADGPnyNS5XB2YTJyFOcCokXVKxfVjw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Le dim. 26 sept. 2021 à 22:41, Jean-Christophe Arnu <jcarnu(at)gmail(dot)com> a
écrit :

>
>
> Le dim. 26 sept. 2021 à 15:55, Artur Zakirov <zaartur(at)gmail(dot)com> a écrit :
>
>> Nice catch! The patch looks good to me.
>> Can you also add a more general test case:
>>
>> =# SELECT $$'' '1' '2'$$::tsvector;
>> ERROR: syntax error in tsvector: "'' '1' '2'"
>> LINE 1: SELECT $$'' '1' '2'$$::tsvector;
>>
>>
> Thank you, Artur for spotting this test.
> It is now included into this patch.
>
>
>
Two more things :

* I updated the documentation for array_to_tsvector(), ts_delete() and
setweight() functions (so here's a new patch);
* I should mention François Ferry from Logilab who first reported the
backup/restore problem that led to this patch.

I think this should be ok, now the doc is up to date.

Kind regards.
--
Jean-Christophe Arnu

Attachment Content-Type Size
empty_string_in_tsvector_v4.patch text/x-patch 7.9 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Kapila 2021-09-27 11:10:50 Re: Column Filtering in Logical Replication
Previous Message Greg Nancarrow 2021-09-27 09:16:46 Re: Added schema level support for publication.