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.96) (envelope-from ) id 1wa8r4-001Yi6-30 for pgsql-bugs@arkaria.postgresql.org; Thu, 18 Jun 2026 09:16:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wa8r2-00AZVF-0X for pgsql-bugs@arkaria.postgresql.org; Thu, 18 Jun 2026 09:16:08 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wa8r1-00AZV7-2w for pgsql-bugs@lists.postgresql.org; Thu, 18 Jun 2026 09:16:07 +0000 Received: from mail-pj1-x102e.google.com ([2607:f8b0:4864:20::102e]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wa8qx-000000014BH-18UA for pgsql-bugs@lists.postgresql.org; Thu, 18 Jun 2026 09:16:07 +0000 Received: by mail-pj1-x102e.google.com with SMTP id 98e67ed59e1d1-36dac5d5da0so282464a91.2 for ; Thu, 18 Jun 2026 02:16:02 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1781774161; cv=none; d=google.com; s=arc-20240605; b=BdkR/JsdQ5qzG69QCP6yJOkimZnoZskgzu7lt2BN4mXr5Ob2R9I5aDI/W+1WsVqAc0 5DPluA99IFBVvSyAHekU2iPNk9TRhkQNu/afILHpcn5niWpFSMq9t33PX+3L8Kk5O7gb wZaLjJJoJ+1nIXwhf2BWzmjmjPkd7u2D+6P7XUgiC919y7DHiVNFma+wcAqSvpxW2Swf /BnVD8dpL/gBcNfHCaSP6rYPV4HshkVnxbEZYGlyHok99TV0Xnsx9ti+sSaQ9IB51mFU OKmmRVCTZ7DbfJkiWpji5L2YpT4MhqdQV9sqoNjnbGblThT4hBhf4B+2B43ZcefW1r1Z 1tJQ== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:dkim-signature; bh=YjpWyoMtuW9GYCK/DowTSOfq3SoHG+AImBiHCzZeapg=; fh=gdxl268g2QCq/CGOUk3Z0Jx6DoCdE9CzfkrZ97rLE/E=; b=IW0kepBlIzesVesnQhpu0ckNjcIIkX2zWx8PBd0u16g4TFjIrAfsQe6IdXwoTODdSY pob+1iGbGEcnNydUEHig2kH1fM5ec4w3FDI+w/MBm5SjG0BuQ25t9aO/RUb2iIvb3YaT jddISGTg/8emplyFAtBiR3ECmjAkLqAjdAHxAT7viXZLdIV+K/OfMw07tfZBAsm5Eirq yFXPJUgMwOztJXDQslvOaRU1Se4oCZGRI8DMrqg+u555SvmtssW2txGInBXYwQNAP1kh 5bDJukwmWNANvq/1uvcJdPQHNkp3z+McymF/opD0cpUBPKcVNJwBC2m1oLsXd8ZLe0o7 xk+w==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1781774161; x=1782378961; darn=lists.postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=YjpWyoMtuW9GYCK/DowTSOfq3SoHG+AImBiHCzZeapg=; b=HfihEfnwx33Hn7nTgeK9IIvjZ6BOhwpdtoVQjs/hvNh2VKA2xKtr9hTlrJI39CCgZs jDnUnLMVrqr7zW6aDxCRUHMwre7yCx0awzHxTeTKzpyYecR4biqGLcdYRHSV5g7tZPtv JrV3+wdz81Cn14xE8Eev3Ow/N1WtJM7hbyrIKzNqPELXWOPnKN5ZhJYhY0tlkqdTuOoE 8xcyAXuoSoFpv5gLjrxaIkFQCUeEzCL6HxJq5Vl+GG9GqtG7Rf4u4IQTckT4MStnI0ia tTptCMyRFPqQUPztfWeyONpGWWZKbdTSq++ISfp3ApwD20BY27vGiLO7tjFWSK/d1PLL yYrA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1781774161; x=1782378961; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-gg:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=YjpWyoMtuW9GYCK/DowTSOfq3SoHG+AImBiHCzZeapg=; b=iWAa5By682sWSt43IDNxV/FaURrVIZbzHNkP4b/+s7yzx0EiWZ5Mmyd2ji9WUd6L/u /wU/HFp/fsnoQu1YZgYn2eyGHLGCJhNtpyIkdwaEEuOjCuP7JjbtPWk01bYyClqeSVxw pMnG/mOr8C5q954BBuJGvpP3Vsdu658A/U0GecDh0TCWJmVepOn8eE3U9eH1TlJ9AH2f FzL+ZmJJYWKPsJ9gRxXBa+UfjJs7NUGOSQbl+rPSgovQ44zO8h2z3tll4zNDOe7ttSnV N6jPmofDbDtRx1uK4+blA9VFCVt04WqyYe3w90qWg6Wqnukm+lZl/Du9IKzqQ8EFyzTc KOEg== X-Forwarded-Encrypted: i=1; AFNElJ+2tg3gH8Z8SXhIF4WBeEGwKduKdc71L4G7N2DLxsmL+FGqXl/UBnhnnFTK8/bnQcYYWVpoPwwwBah5@lists.postgresql.org X-Gm-Message-State: AOJu0Yx0kS4VYCV4I8SDi9B6US1kOBBVHY3TCk/B3ukoM8WCBckB5vD6 KZsTGI24/XU0cH718sBSwHX4rP9Efzp4zejlJQ5Xlz1GEIL9bj49ztuaAD4h4wN/8EVWPSApqol TgjJaQZOr0w4/uLwJniQBOOKxFzYKt1Y= X-Gm-Gg: AfdE7cn2G5517DKIl3iUCO4uuZA6uDgyrOpbgd1uNDcavLkoJbyr3Je6SpJ8fgRRvT3 tqvIrwPoLv2Hw8RkugfR60sWFYgCGhU0et0k2HXFl1Lf5NeYDZYqwy773GSw6pf8rfEpUwusr19 fG8654vxirwLtSq5FCOjouP4UNsRXiR4IFKzy4x+YF0efgt8BOw3rRm31+6igNcSVt7GJMK/BhL Oy8G9Tl7jsb87kvlMYBg1LHyt0NM1H8gc/7hCFKZ94G8f0s7QJGbZ3GTXr/UnGdh/mnU5wzbWSO LWZnWbDLHEz6RW+/mVJNyFhS1A3S7Gelqwg0WLC/OkuG/BS56iPBiA== X-Received: by 2002:a17:90a:d44b:b0:36b:b1f4:e0ac with SMTP id 98e67ed59e1d1-37c9366b4e9mr7606424a91.14.1781774160806; Thu, 18 Jun 2026 02:16:00 -0700 (PDT) MIME-Version: 1.0 References: <19484-a3cb82c8cde3c8fa@postgresql.org> In-Reply-To: From: Amit Langote Date: Thu, 18 Jun 2026 18:15:44 +0900 X-Gm-Features: AVVi8Cd6K9wITYa6juZHeIV8FOcZqy3JFMPzhzzbWa6lwToOw6VQoo5rgD-gaGM Message-ID: Subject: Re: BUG #19484: Segmentation fault triggered by FDW To: Etsuro Fujita Cc: Matheus Alcantara , Ayush Tiwari , Rafia Sabih , 798604270@qq.com, pgsql-bugs@lists.postgresql.org, Amit Langote Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Fujita-san, On Thu, Jun 11, 2026 at 7:44=E2=80=AFPM Amit Langote wrote: > > Hi Fujita-san, > > On Thu, Jun 11, 2026 at 7:41=E2=80=AFPM Etsuro Fujita wrote: > > > > Amit-san, > > > > On Wed, Jun 10, 2026 at 10:27=E2=80=AFPM Amit Langote wrote: > > > Before committing it, I'd like to wait briefly to see if Fujita-san > > > has any thoughts on the FDW-side concerns, since he has already chime= d > > > in on the thread. > > > > I'll review the patch as early as I can next week, but if you want to > > commit it quickly, please go ahead. > > No problem; I'll hold off. A small clarification on this one: the patch makes no changes to postgres_fdw code, only adds a regression test. The bug, which I introduced, is in how nodeModifyTable.c supplies fdw_private from the pruned/validated fdwPrivLists in ModifyTableState rather than the original list in ModifyTable, so the postgres_fdw side itself is unchanged. The substantive change is the executor re-indexing. Still holding off on committing per our exchange, but no rush given you may want to prioritize the v19 open items. Happy to go ahead whenever, or wait for your comments. --=20 Thanks, Amit Langote