Content-Type: multipart/alternative;
 boundary="------------8zeELpGmq4NT1iSZcmNK6KTP"
Message-ID: <9481c16e-8477-eb73-4e20-91bb1a13e2e0@gmail.com>
Date: Fri, 19 Jan 2024 12:00:00 +0300
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101
 Thunderbird/102.4.2
Subject: Re: BUG #18297: Error when adding a column to a parent table with
 complex inheritance
Content-Language: en-US
To: Tender Wang <tndrwang@gmail.com>
Cc: Richard Guo <guofenglinux@gmail.com>, pgsql-bugs@lists.postgresql.org
References: <18297-b04cd83a55b51e35@postgresql.org>
 <CAHewXNkjMSzka_sGjtSysDRZpG93j5a=8ebq6f3Gcuo-xAGygw@mail.gmail.com>
 <CAMbWs48DPeuusHFaZ8xk=ag6TbhfqtF9KUEUMmb3nY7zPYCBdA@mail.gmail.com>
 <CAHewXNnhOgY4jTHKa2F1zJdtxUECmEMzV_VANnCNTuL3+_Bx6A@mail.gmail.com>
 <38de09cc-70f3-28ee-fe67-ae13cba23e61@gmail.com>
 <CAHewXN=dPJDvaoME0G9vyemUmY-TpDuqQfcHJRWfUvSWX1p=rQ@mail.gmail.com>
From: Alexander Lakhin <exclusion@gmail.com>
In-Reply-To: 
 <CAHewXN=dPJDvaoME0G9vyemUmY-TpDuqQfcHJRWfUvSWX1p=rQ@mail.gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/9481c16e-8477-eb73-4e20-91bb1a13e2e0%40gmail.com>
Precedence: bulk

This is a multi-part message in MIME format.
--------------8zeELpGmq4NT1iSZcmNK6KTP
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit

18.01.2024 18:42, Tender Wang wrote:

>
> I think we can sort the role_addresses list and skip the same role id. I don't intend to fix above two issues in one 
> patch.
> So I add a new 0001 attached patch.
>
>
>     Perhaps, you would like to fix it in passing too. I've rechecked all the
>     other object types, that can be DROPped with a list (namely, AGGREGATE,
>     DOMAIN, EXTENSION, FOREIGN DATA WRAPPER, FOREIGN TABLE, FUNCTION, INDEX,
>     MATERIALIZED VIEW, OPERATOR, PROCEDURE, ROUTINE, SEQUENCE, SERVER,
>     STATISTICS, TABLE, TYPE, VIEW), and found that all of these handle
>     such duplicate entries with no error.
>
>
> I'm not sure if there are other problems like this.
>

Yes, I've encountered a similar issue, this time with ALTER (TEXT SEARCH
CONFIGURATION):
CREATE TEXT SEARCH CONFIGURATION ispell_tst (COPY=english);
CREATE TEXT SEARCH DICTIONARY ispell (Template=ispell, DictFile=ispell_sample, AffFile=ispell_sample);
ALTER TEXT SEARCH CONFIGURATION ispell_tst ALTER MAPPING FOR word, word WITH ispell;
ERROR:  tuple already updated by self

And again, I could not get similar errors with all the other ALTER commands,
that accept lists.

Sorry for mixing two different problems together, I should have reported it
separately.

Best regards,
Alexander
--------------8zeELpGmq4NT1iSZcmNK6KTP
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <div class="moz-cite-prefix">18.01.2024 18:42, Tender Wang wrote:<br>
      <br>
    </div>
    <blockquote type="cite"
cite="mid:CAHewXN=dPJDvaoME0G9vyemUmY-TpDuqQfcHJRWfUvSWX1p=rQ@mail.gmail.com">
      <meta http-equiv="content-type" content="text/html; charset=UTF-8">
      <div dir="ltr">
        <div dir="ltr">
          <div>
            <div class="gmail_quote"><br>
              <div>I think we can sort the role_addresses list and skip
                the same role id. I don't intend to fix above two issues
                in one patch.</div>
              <div>So I add a new 0001 attached patch.</div>
              <div><br>
              </div>
              <div><br>
              </div>
              <blockquote class="gmail_quote" style="margin:0px 0px 0px
                0.8ex;border-left:1px solid
                rgb(204,204,204);padding-left:1ex">
                <div> Perhaps, you would like to fix it in passing too.
                  I've rechecked all the<br>
                  other object types, that can be DROPped with a list
                  (namely, AGGREGATE,<br>
                  DOMAIN, EXTENSION, FOREIGN DATA WRAPPER, FOREIGN
                  TABLE, FUNCTION, INDEX,<br>
                  MATERIALIZED VIEW, OPERATOR, PROCEDURE, ROUTINE,
                  SEQUENCE, SERVER,<br>
                  STATISTICS, TABLE, TYPE, VIEW), and found that all of
                  these handle<br>
                  such duplicate entries with no error.<br>
                </div>
              </blockquote>
              <div><br>
              </div>
              <div>I'm not sure if there are other problems like this.<br>
              </div>
              <br>
            </div>
          </div>
        </div>
      </div>
    </blockquote>
    <br>
    Yes, I've encountered a similar issue, this time with ALTER (TEXT
    SEARCH<br>
    CONFIGURATION):<br>
    CREATE TEXT SEARCH CONFIGURATION ispell_tst (COPY=english);<br>
    CREATE TEXT SEARCH DICTIONARY ispell (Template=ispell,
    DictFile=ispell_sample, AffFile=ispell_sample);<br>
    ALTER TEXT SEARCH CONFIGURATION ispell_tst ALTER MAPPING FOR word,
    word WITH ispell;<br>
    ERROR:  tuple already updated by self<br>
    <br>
    And again, I could not get similar errors with all the other ALTER
    commands,<br>
    that accept lists.<br>
    <br>
    Sorry for mixing two different problems together, I should have
    reported it<br>
    separately.<br>
    <br>
    Best regards,<br>
    Alexander<br>
  </body>
</html>

--------------8zeELpGmq4NT1iSZcmNK6KTP--