Re: BUG #17713: Assert with postgres_fdw in v12

From: Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com>
To: Richard Guo <guofenglinux(at)gmail(dot)com>
Cc: tharakan(at)gmail(dot)com, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #17713: Assert with postgres_fdw in v12
Date: 2022-12-14 10:02:58
Message-ID: CAPmGK14UADSn3KPgNRFBh9i-eUTSyiLMp0BMMYLNuH2c5Th+GA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi Richard,

On Tue, Dec 13, 2022 at 12:20 PM Richard Guo <guofenglinux(at)gmail(dot)com> wrote:
> On Mon, Dec 12, 2022 at 7:10 PM PG Bug reporting form <noreply(at)postgresql(dot)org> wrote:
>> This is a repro that triggers an assert (only) in REL_12_STABLE. In
>> particular the issue seems to have begun after this commit -
>> 08d2d58a2a1c8ef8d39e8132d39ee14a1d029500. The foreign table
>> is empty so am unsure if Assert()'s expectations are valid.
>>
>> Since all versions v13+ seem to work okay, it is possible that a future
>> bug-fix was not backpatched far enough to v12.
>
> Yes, I think it is 5e7fa189e, which should be back-patched to v12.

That was also pointed out by Robins:

https://www.postgresql.org/message-id/CAEP4nAza%2B0fTCLkgkKYux3JDo3tUBTQORehP%2BaCxSNURpSFpHw%40mail.gmail.com

Will back-patch to v12 as well. Thanks for looking at this!

Best regards,
Etsuro Fujita

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Daniel Gustafsson 2022-12-14 10:22:58 Re: Sort bug
Previous Message PG Bug reporting form 2022-12-14 09:07:45 BUG #17720: pg_dump creates a dump with primary key that cannot be restored, when specifying 'using index ...'