what i means is thread pool issue, use same thread run several SQL may not
work on rarely situation.
maybe when run update statement need use a new connection to make previous
"SELECT sync_zhprs_custom_word()" take effect?
在2021年11月23日星期二 UTC+8 上午3:20:11<Billy Zheng> 写道：
> In fact, not too many ... it just
>
> 1. add a zhparser ts config use pg extension,
> 2. add a stored generated column column to generate tsvector column (“美元”
> is not as lexor token)
> 3. Use following code to add "美元“ as lex token
> DB.run(Sequel.lit("INSERT INTO zhparser.zhprs_custom_word values(?)
> ON CONFLICT DO NOTHING;", '美元'))
> DB.run("SELECT sync_zhprs_custom_word();") # this function i paste
> before
> 4. Run update statement to make generated column column get updated
> automatically. (ruby-pg work, sequel not work)
>
> Sorry, i don't know how to add a alphabet lexor into `english` ts config
> or whatever to reproduce this issue, maybe can reproduce on that, maybe not.
>
> one more question please, why do you not consider this is a issue relative
> to thread?
>
> 在2021年11月23日星期二 UTC+8 上午2:59:04<Jeremy Evans> 写道：
>
>> On Mon, Nov 22, 2021 at 10:55 AM Billy Zheng <[email protected]> wrote:
>>
>>> > I cannot see why the first two would cause a problem, but maybe the
>>> last one does? You can turn that off via the :use_iso_date_format=>false
>>> option when
>>> setting up your Database connection.
>>>
>>> I consider not caused by those option, because following code still not
>>> work. (after revert above hack in acquire method)
>>>
>>> ```
>>> DB = Sequel.connect(DB_URL, :use_iso_date_format => false,
>>> :force_standard_strings => false)
>>>
>>> # many code, ellipsis ...
>>>
>>> DB.run(Sequel.lit("update investing_latest_news set title=title"))
>>>
>>
>> If you avoid the many code, and run DB.run directly after DB =
>> Sequel.connect, does it work then?
>>
>> Thanks,
>> Jeremy
>>
>
--
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/sequel-talk/503feba8-6000-4449-ab08-297bc4dfcd26n%40googlegroups.com.
