Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-bugs-owner+archive@lists.postgresql.org>)
	id 1uB4yt-006E5g-ER
	for pgsql-bugs@arkaria.postgresql.org; Sat, 03 May 2025 05:00:07 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-bugs-owner+archive@lists.postgresql.org>)
	id 1uB4yr-00DOw9-DO
	for pgsql-bugs@arkaria.postgresql.org; Sat, 03 May 2025 05:00:06 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <exclusion@gmail.com>)
	id 1uB4yr-00DOw1-55
	for pgsql-bugs@lists.postgresql.org; Sat, 03 May 2025 05:00:06 +0000
Received: from mail-lf1-x12b.google.com ([2a00:1450:4864:20::12b])
	by makus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.96)
	(envelope-from <exclusion@gmail.com>)
	id 1uB4yp-000nXe-37
	for pgsql-bugs@lists.postgresql.org;
	Sat, 03 May 2025 05:00:05 +0000
Received: by mail-lf1-x12b.google.com with SMTP id
 2adb3069b0e04-5493b5bc6e8so3246295e87.2
        for <pgsql-bugs@lists.postgresql.org>;
 Fri, 02 May 2025 22:00:04 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20230601; t=1746248403; x=1746853203;
 darn=lists.postgresql.org;
        h=in-reply-to:from:content-language:references:cc:to:subject
         :user-agent:mime-version:date:message-id:from:to:cc:subject:date
         :message-id:reply-to;
        bh=nE2oJ+K3na6wxMnBwyzSmLu32t50fxLH/S9wcZ5XDN8=;
        b=BdwQ//RrBfcRkjWDxheXVzpzMDriFuTvE6jcm5CkBOcQA+hz7jBvZKgthHa89l0+tx
         OmJHJ5W6AoY1fvsqxLRmcFhcDC2StNRidOnq2yxrtJJHpn8MxN1bOBU3HBH48vFuC0+H
         5s2dTzdM8XMWFRf6rQkXNMgiYDjJnzbundf7qNZtoqcTBDO/sUW6TrXBUPIDoaHskL0R
         /+r1pXUbbH5SW6xoTr0gySriBsKaCEDpcdqPr345ILJnKbJTko3M3tLMJMcJpsVgq7ll
         5PCdL3Xpp86bAVIcMdDKfg1fvQqh2lfr0uDWp0+UTcAnmDM5qEC/oj7t8/zUxvJqOg7B
         F4Vg==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1746248403; x=1746853203;
        h=in-reply-to:from:content-language:references:cc:to:subject
         :user-agent:mime-version:date:message-id:x-gm-message-state:from:to
         :cc:subject:date:message-id:reply-to;
        bh=nE2oJ+K3na6wxMnBwyzSmLu32t50fxLH/S9wcZ5XDN8=;
        b=LWJMRe8mF1zfrq0kjlOv8MBdI6Qa7QwgaHL7iVfswnKSnAxP/FoeirLxyMwPNEzyrH
         mGGkjFOrBQk1SErnJbekHYrFOjkJnyRuN8vk7AxfaFLAJ8qkHhOjf/sV43Sryk7Qq3dd
         3vGs2+d32zTGCNSEaTpHODj1TSEEbXQQslWSJCX2yA26lXy1MhV2skV52siZIr8K7nhr
         4eZ5YTjFvoK09Q8E1YrlW+TjUXBL0pwSabyAJ5GcGH1ZqILQTaIutcn2KRNy83ty46JJ
         HtO6WlQkanvJvunz4uyUOUVuM0oWWYIy3KkML4mDi4RcpsY39i9TDQ6apwqQBm0OrJzx
         dVGg==
X-Forwarded-Encrypted: i=1;
 AJvYcCXw5A9mExCiAHzfel8liz+3QtqEx/jVa/9W+xpchIDTDaGipptWNvsFy+5AgwTKalSuEitPYC13dWTf@lists.postgresql.org
X-Gm-Message-State: AOJu0YzIhP4nq0kgunu/Up64EvBHh1XdEMnmsOdSl9bpouDsv9NWr0ps
	Xk0f4IGlb3YNmMshOathue7stamkUR5xQafquXwXQHbGpIlr+KHz
X-Gm-Gg: ASbGncusJU6995JjAZKrvt5wFyc3LSdwyKxZi3ckAxegO/NmdFOVglbxQXm1H7m7D5H
	mykdvf4n0f2dNm9D/oJDXtwkabNlFafm8VQb3pze1t6lM5MIrc7H1vJ2/EoU3qxKE8brf0AkQh+
	3wy1PykTbxJQlX4w4wvxIyixv7oAHIJ49jmpWsOi+OvPC/mw4MfnNmSbquRTBEl267iYhNYvHik
	ZWRNX0d+INJ5yracsZayRtgyCxGkdasc0jT6WFHVm7V51UZtuQCgoewqtTzBs608vvJmZf0IEjG
	89i0roduOdCOy3oWNMg34OonJjfS3zLAIeEak4L/17I=
X-Google-Smtp-Source: 
 AGHT+IE4UIo4HJ2hGWqXyWCbD6u4L3eOKHzDJ84EwsfCJo4kESCL90TrLagvMEkIzQRYCgwXSrTWrg==
X-Received: by 2002:a05:6512:3d8d:b0:54e:93cf:338d with SMTP id
 2adb3069b0e04-54eac1f0b19mr1786937e87.12.1746248402220;
        Fri, 02 May 2025 22:00:02 -0700 (PDT)
Received: from [192.168.0.50] ([89.149.68.176])
        by smtp.gmail.com with ESMTPSA id
 2adb3069b0e04-54ea94bf0e4sm632951e87.60.2025.05.02.22.00.01
        (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128);
        Fri, 02 May 2025 22:00:01 -0700 (PDT)
Content-Type: multipart/alternative;
 boundary="------------27kxyKZ9JD1IHVbQDo4PAHDf"
Message-ID: <f1456753-86cf-414c-bac0-87ce1beb498f@gmail.com>
Date: Sat, 3 May 2025 08:00:00 +0300
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: BUG #18741: Detaching a partition referencing a partitioned table
 fails with a trigger-related error
To: Tender Wang <tndrwang@gmail.com>
Cc: Alvaro Herrera <alvherre@alvh.no-ip.org>, pgsql-bugs@lists.postgresql.org
References: <18741-e4ef6f7aa8a956cb@postgresql.org>
 <CAHewXNmmU70OsO=P2F9RxitY2EdLxSOrA=tUHP0N-6wS99SYTQ@mail.gmail.com>
Content-Language: en-US
From: Alexander Lakhin <exclusion@gmail.com>
In-Reply-To: 
 <CAHewXNmmU70OsO=P2F9RxitY2EdLxSOrA=tUHP0N-6wS99SYTQ@mail.gmail.com>
List-Id: <pgsql-bugs.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-bugs@lists.postgresql.org>
List-Owner: <mailto:pgsql-bugs-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-bugs>
Archived-At: 
 <https://www.postgresql.org/message-id/f1456753-86cf-414c-bac0-87ce1beb498f%40gmail.com>
Precedence: bulk

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

Hello Tender Wang,

03.05.2025 04:22, Tender Wang wrote:
>
> PG Bug reporting form <noreply@postgresql.org> 于2024年12月8日周日 22:43写道：
>
>     The following bug has been logged on the website:
>
>     Bug reference:      18741
>
>
> This issue can't be reproduced on HEAD. I guess a commit happened to solve this problem.

Thank you for the testing this!
Yes, according to `git bisect` it is fixed by 9b21f203d.

Best regards,
Alexander Lakhin
Neon (https://neon.tech)
--------------27kxyKZ9JD1IHVbQDo4PAHDf
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<!DOCTYPE html>
<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <div class="moz-cite-prefix">Hello Tender Wang,<br>
      <br>
      03.05.2025 04:22, Tender Wang wrote:<br>
    </div>
    <blockquote type="cite"
cite="mid:CAHewXNmmU70OsO=P2F9RxitY2EdLxSOrA=tUHP0N-6wS99SYTQ@mail.gmail.com">
      <meta http-equiv="content-type" content="text/html; charset=UTF-8">
      <div dir="ltr"><br>
        <div class="gmail_quote gmail_quote_container">
          <div dir="ltr" class="gmail_attr">PG Bug reporting form &lt;<a
              href="mailto:noreply@postgresql.org"
              moz-do-not-send="true" class="moz-txt-link-freetext">noreply@postgresql.org</a>&gt;
            于2024年12月8日周日 22:43写道：<br>
          </div>
          <blockquote class="gmail_quote"
style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">The
            following bug has been logged on the website:<br>
            <br>
            Bug reference:      18741<br>
            <br>
          </blockquote>
        </div>
        <div><br clear="all">
        </div>
        <div>This issue can't be reproduced on HEAD. I guess a commit
          happened to solve this problem.</div>
      </div>
    </blockquote>
    <br>
    Thank you for the testing this!<br>
    Yes, according to `git bisect` it is fixed by 9b21f203d.<br>
    <br>
    Best regards,<br>
    Alexander Lakhin <br>
    Neon (<a class="moz-txt-link-freetext" href="https://neon.tech">https://neon.tech</a>)
  </body>
</html>

--------------27kxyKZ9JD1IHVbQDo4PAHDf--