On Tue, Nov 3, 2026 at 1:58 PM Henson Choi <[email protected]> wrote:
>
> Hi Nitin,
>
> I have looked at v2.  Below are my notes on the multi-parent scenario,
> and on how the backend problem where the restored child loses its
> inherited CHECK constraint shows up with v2.
>

Hi.

+ appendPQExpBuffer(q,
+  "ALTER %sTABLE ONLY %s ALTER COLUMN %s SET EXPRESSION AS (%s);\n",
+  foreign, qualrelname, fmtId(tbinfo->attnames[adnum - 1]),
+  adinfo->adef_expr);

ALTER COLUMN SET EXPRESSION
has some problems with dependencies, see [1] and [2]

[1]: 
https://www.postgresql.org/message-id/CACJufxEXY8O5rPLoieo1WoqbuO2ajCEJzVkXcykNtsyij8rEyA%40mail.gmail.com
[2]: 
https://www.postgresql.org/message-id/flat/CACJufxEomSz3BwUGfk8A6MeAKj%3DCki5B%2BgYTbJO%3DACCJyytWZg%40mail.gmail.com



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


Reply via email to