Hi Zsolt,

Thanks for catching both, v6 attached.

> But it can with a combined alter:

The check ran before the ADD COLUMN, so the column did not exist yet.
v6 runs it when SET EXPRESSION executes, and your example now fails
like the two statement form.

> But that hint won't work, as the testcase shows.

v6 gives the hint only for partitions, since a partition always has a
single top-level parent.

A simpler option is to reject the combined command, as ALTER COLUMN
TYPE does for a column added by the same command. I'm happy to switch
if that is preferred.

Thanks,
Shihao

Attachment: v6-0001-Require-child-tables-to-use-the-parent-s-virtual-gen.patch
Description: Binary data

Attachment: nocfbot-v6-REL_18-0001-Require-child-tables-to-use-the-parent-s-virtual-gen.patch
Description: Binary data

Reply via email to