pg.ddx.io pgsql-committers@postgresql.org mailing list archivehelp / color / mirror / Atom feed
pgsql: SET NOT NULL: Call object-alter hook only after the catalog chan 2+ messages / 1 participants [nested] [flat]
* pgsql: SET NOT NULL: Call object-alter hook only after the catalog chan @ 2026-03-20 13:42 Álvaro Herrera <alvherre@kurilemu.de> 0 siblings, 0 replies; 2+ messages in thread From: Álvaro Herrera @ 2026-03-20 13:42 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org SET NOT NULL: Call object-alter hook only after the catalog change ... otherwise, the function invoked by the hook might consult the catalog and not see that the new constraint exists. This relies on set_attnotnull doing CommandCounterIncrement() after successfully modifying the catalog. Oversight in commit 14e87ffa5c54. Author: Artur Zakirov <zaartur@gmail.com> Backpatch-through: 18 Discussion: https://postgr.es/m/CAKNkYnxUPCJk-3Xe0A3rmCC8B8V8kqVJbYMVN6ySGpjs_qd7dQ@mail.gmail.com Branch ------ REL_18_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/6958077ceb934f5a0c00f95b673fb86d5a7dde95 Modified Files -------------- src/backend/commands/tablecmds.c | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) ^ permalink raw reply [nested|flat] 2+ messages in thread
* pgsql: SET NOT NULL: Call object-alter hook only after the catalog chan @ 2026-03-20 13:42 Álvaro Herrera <alvherre@kurilemu.de> 0 siblings, 0 replies; 2+ messages in thread From: Álvaro Herrera @ 2026-03-20 13:42 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org SET NOT NULL: Call object-alter hook only after the catalog change ... otherwise, the function invoked by the hook might consult the catalog and not see that the new constraint exists. This relies on set_attnotnull doing CommandCounterIncrement() after successfully modifying the catalog. Oversight in commit 14e87ffa5c54. Author: Artur Zakirov <zaartur@gmail.com> Backpatch-through: 18 Discussion: https://postgr.es/m/CAKNkYnxUPCJk-3Xe0A3rmCC8B8V8kqVJbYMVN6ySGpjs_qd7dQ@mail.gmail.com Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/e7975f1c06b585dcda645c6047e6f37cdfacce84 Modified Files -------------- src/backend/commands/tablecmds.c | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2026-03-20 13:42 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2026-03-20 13:42 pgsql: SET NOT NULL: Call object-alter hook only after the catalog chan Álvaro Herrera <alvherre@kurilemu.de> 2026-03-20 13:42 pgsql: SET NOT NULL: Call object-alter hook only after the catalog chan Álvaro Herrera <alvherre@kurilemu.de>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox