Re: BUG #18970: Atempt to alter type of table column used in row type with check leads to assertion failure

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

From: Tom Lane <tgl@sss.pgh.pa.us>
To: jian he <jian.universality@gmail.com>
Cc: exclusion@gmail.com, pgsql-bugs@lists.postgresql.org
Date: 2025-06-30T02:23:30Z
Lists: pgsql-bugs
jian he <jian.universality@gmail.com> writes:
> This issue also applies to tab->changedStatisticsOids
> and tab->changedIndexOids in ATPostAlterTypeCleanup.

Oh, indeed :-(

> We likely need to do the same as well.

I'm about done for the day --- you want to prepare the patch?

			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. Obtain required table lock during cross-table constraint updates.

  2. Add assertions that we hold some relevant lock during relation open.