Re: BUG #17781: Assert in setrefs.c

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Robins Tharakan <tharakan@gmail.com>
Cc: pgsql-bugs@lists.postgresql.org
Date: 2023-02-08T19:46:27Z
Lists: pgsql-bugs
Robins Tharakan <tharakan@gmail.com> writes:
> Assuming this persistence is helpful overall, now I see a
> different SQL can still trigger the same assert().

It's very helpful, thank you!  I pushed Richard's fix for this.

			regards, tom lane



Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →
  1. Further fixes in qual nullingrel adjustment for outer join commutation.

  2. Further tighten nullingrel marking rules in build_joinrel_tlist().

  3. remove_rel_from_query() must clean up PlaceHolderVar.phrels fields.

  4. Rethink nullingrel marking rules in build_joinrel_tlist().

  5. Make Vars be outer-join-aware.