Re: Prevent internal error at concurrent CREATE OR REPLACE FUNCTION
От
Yugo Nagata
Тема
Re: Prevent internal error at concurrent CREATE OR REPLACE FUNCTION
Дата
Msg-id
20250704000659.930b9b977165cb7ac693cb09@sraoss.co.jp
Список
Дерево обсуждения
Prevent internal error at concurrent CREATE OR REPLACE FUNCTION Yugo Nagata <nagata@sraoss.co.jp>
Re: Prevent internal error at concurrent CREATE OR REPLACE FUNCTION Yugo Nagata <nagata@sraoss.co.jp>
Re: Prevent internal error at concurrent CREATE OR REPLACE FUNCTION Alexander Lakhin <exclusion@gmail.com>
Re: Prevent internal error at concurrent CREATE OR REPLACE FUNCTION Yugo Nagata <nagata@sraoss.co.jp>
Re: Prevent internal error at concurrent CREATE OR REPLACE FUNCTION Yugo Nagata <nagata@sraoss.co.jp>
Re: Prevent internal error at concurrent CREATE OR REPLACE FUNCTION Yugo Nagata <nagata@sraoss.co.jp>
Re: Prevent internal error at concurrent CREATE OR REPLACE FUNCTION Daniil Davydov <3danissimo@gmail.com>
Re: Prevent internal error at concurrent CREATE OR REPLACE FUNCTION Yugo Nagata <nagata@sraoss.co.jp>
Re: Prevent internal error at concurrent CREATE OR REPLACE FUNCTION Daniil Davydov <3danissimo@gmail.com>
Re: Prevent internal error at concurrent CREATE OR REPLACE FUNCTION Jim Jones <jim.jones@uni-muenster.de>
Re: Prevent internal error at concurrent CREATE OR REPLACE FUNCTION Yugo Nagata <nagata@sraoss.co.jp>
Re: Prevent internal error at concurrent CREATE OR REPLACE FUNCTION Jim Jones <jim.jones@uni-muenster.de>
Re: Prevent internal error at concurrent CREATE OR REPLACE FUNCTION Yugo Nagata <nagata@sraoss.co.jp>
Re: Prevent internal error at concurrent CREATE OR REPLACE FUNCTION jian he <jian.universality@gmail.com>
Re: Prevent internal error at concurrent CREATE OR REPLACE FUNCTION Yugo Nagata <nagata@sraoss.co.jp>
Re: Prevent internal error at concurrent CREATE OR REPLACE FUNCTION jian he <jian.universality@gmail.com>
Re: Prevent internal error at concurrent CREATE OR REPLACE FUNCTION Yugo Nagata <nagata@sraoss.co.jp>
On Thu, 3 Jul 2025 23:18:12 +0900
Yugo Nagata wrote:
> On Tue, 1 Jul 2025 18:56:11 +0700
> Daniil Davydov <3danissimo@gmail.com> wrote:
> > For example, with this patch such a query : "CREATE TYPE mood AS ENUM
> > ('happy', 'sad', 'happy');"
> > Will throw this error : "operation failed due to a concurrent command"
> > Of course, it isn't true
>
> You're right ― this error is not caused by a concurrent command.
> However, I believe the error message in cases like creating an ENUM type with
> duplicate labels could be improved to explain the issue more clearly, rather
> than just reporting it as a unique constraint violation.
I have submitted a patch addressing this in a separate thread [1].
[1] https://www.postgresql.org/message-id/20250704000402.37e605ab0c59c300965a17ee%40sraoss.co.jp
Regards,
Yugo Nagata
--
Yugo Nagata
В списке pgsql-hackers по дате отправления
От: Zhou, Zhiguo
Дата:
