Re: let ALTER TABLE DROP COLUMN drop whole-row referenced object

jian he <jian.universality@gmail.com>

From: jian he <jian.universality@gmail.com>

To: lakshmi <lakshmigcdac@gmail.com>

Cc: pgsql-hackers <pgsql-hackers@postgresql.org>, 金 <jinbinge@126.com>, Kirill Reshke <reshkekirill@gmail.com>, Chao Li <li.evan.chao@gmail.com>

Date: 2026-05-25T06:43:56Z

Lists: pgsql-hackers

Attachments

v9-0002-fix-DDL-wholerow-referenced-triggers.patch (text/x-patch)
v9-0003-fix-DDL-wholerow-referenced-policies.patch (text/x-patch)
v9-0001-fix-DDL-wholerow-referenced-constraints-and-indexes.patch (text/x-patch)

Hi.

[1] rebuilds whole-row dependencies for ALTER COLUMN SET EXPRESSION,
this thread addresses whole-row dependencies for ALTER TABLE DROP
COLUMN and ALTER COLUMN SET DATA TYPE.

Overall, the attached v9 doesn't include any major changes.
It just contains some refactoring to make the coding style consistent with [1].

[1] https://commitfest.postgresql.org/patch/6755



--
jian
https://www.enterprisedb.com/