回复: UPDATE run check constraints for affected columns only

Hi, +1 on Tom's point about BEFORE UPDATE triggers. I also noticed that in execReplication.c, ExecSimpleRelationUpdate() passes CMD_INSERT to ExecConstraints(): ExecConstraints(CMD_INSERT, resultRelInfo, slot, estate); I think this should be CMD_UPDATE? Regards, Yuan Li(carol) -邮件原件--

回复: [PATCH] Add pg_get_role_ddl() functions for role recreation

een released, rolname is a dangling pointer and we risk reading garbage or crashing later. To fix this, copy the role name before releasing the syscache, e.g. rolname = pstrdup(NameStr(roleform->rolname));, and free it at the end. BR, Yuan Li (Carol) -邮件原件- 发件人: Bryan Green 发送时间: 2025年1