Re: BUG #19827: postgres_fdw: Assert in add_foreign_ordered_paths() with redundant ORDER BY in set-op input

From: Robins Tharakan <tharakan(at)gmail(dot)com>
To: Álvaro Herrera <alvherre(at)kurilemu(dot)de>
Cc: David Rowley <dgrowleyml(at)gmail(dot)com>, pgsql-bugs(at)lists(dot)postgresql(dot)org, Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com>
Subject: Re: BUG #19827: postgres_fdw: Assert in add_foreign_ordered_paths() with redundant ORDER BY in set-op input
Date: 2026-11-04 11:30:34
Message-ID: CAEP4nAzvUWOuPMtsb7a7qTiQz6BxEs2=cET_2+ZU5LHhnfFuiw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi Alvaro,

On Wed, 4 Nov 2026 at 20:45, Álvaro Herrera <alvherre(at)kurilemu(dot)de> wrote:

> On 2026-Nov-03, Robins Tharakan wrote:
>
> > On Tue, 3 Nov 2026 at 11:44, David Rowley <dgrowleyml(at)gmail(dot)com> wrote:
>
> > > (I don't seem to have any emails to see what you're replying to here,
> > > and [1] doesn't seem to have any matches apart from your email.)
> >
> > It is odd that despite receiving an email via the web-form submission
> process,
> > it is missing from the pgsql-bugs web-portal today. At this point, it
> seems like
> > a bug with the web-form / mailing system.
>
> I'm sure there are bugs, but this is not one of them.
>
> It's just that all pgsql-bugs submissions via the web interface go
> through human moderation; but you (as submitter) also got the copy that
> we CC to you directly. The pgsql-bugs one was not approved until a few
> hours later, but David had already received the direct CC reply that you
> sent quoting the direct CC you had received, before any pgsql-bugs
> moderators had a chance to approve the original email.
>
> These emails have now been approved and the entirety of the thread can
> be seen in the pgsql-bugs archives.
>
>
> https://www.postgresql.org/message-id/flat/19827-6e0bc0f9a5226e71%40postgresql.org
>
>
Thanks, this explanation makes perfect sense. My apologies for
the confusion. I'll await the mailing-list web portal to show up the
original bug-submission (so that I can be sure everyone's got a
copy) before posting follow-ups.

-
Robins

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Daniel Gustafsson 2026-11-04 12:13:38 Re: set_config(‘search_path’) does not truncate names over 63 bytes, unlike SET
Previous Message Tender Wang 2026-11-04 11:25:42 Re: BUG #19802: MERGE into a partitioned table fails with "SubPlan found with no parent plan"