Re: BUG #18310: Some SQL commands fail to process duplicate objects with error: tuple already updated by self

Поиск
Список
Период
Сортировка
От Tender Wang
Тема Re: BUG #18310: Some SQL commands fail to process duplicate objects with error: tuple already updated by self
Дата
Msg-id CAHewXNk5yeUo2XPaqTYSfbkKhEBfKd4VYa7NHv2MzV-mJ9ULpA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BUG #18310: Some SQL commands fail to process duplicate objects with error: tuple already updated by self  (Tender Wang <tndrwang@gmail.com>)
Ответы Re: BUG #18310: Some SQL commands fail to process duplicate objects with error: tuple already updated by self  (Yongtao Huang <yongtaoh2022@gmail.com>)
Re: BUG #18310: Some SQL commands fail to process duplicate objects with error: tuple already updated by self  (Michael Paquier <michael@paquier.xyz>)
Список pgsql-bugs
Дерево обсуждения


Tender Wang <tndrwang@gmail.com> 于2024年1月26日周五 12:54写道：


Michael Paquier <michael@paquier.xyz> 于2024年1月26日周五 11:41写道：
On Fri, Jan 26, 2024 at 11:33:24AM +0800, Tender Wang wrote:
> How about using list *res replace int *res in getTokenTypes(), so we can
> use list_append_unique().
> In outer function, use list *tokens to replace int *tokens, and ntokens =
> list_length(tokens) not list_length(stmt->tokentype).

Yeah, I was wondering about this code path.  If you feel strongly
about that, would you like to write a patch?
 
Ok,  I try to fix it.
 
As I said before, return List looks like not complicated to solve this issue.
I found another problem, it didn't report NOTICE if SQL has IF EXISTS, for example:

postgres=# alter text search configuration ispell_tst drop mapping if exists for test;
ERROR:  token type "test" does not exist

So I change the func getTokenTypes() interface and remove DropConfigurationMapping() error report into getTokenTypes().


--
Michael


--
Tender Wang
OpenPie:  https://en.openpie.com/


--
Tender Wang
OpenPie:  https://en.openpie.com/
Вложения

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Tender Wang
Дата:
Сообщение: Re: BUG #18310: Some SQL commands fail to process duplicate objects with error: tuple already updated by self
Следующее
От: Alexander Lakhin
Дата:
Сообщение: Re: [BUG] false positive in bt_index_check in case of short 4B varlena datum