• Tom Lane's avatar
    Fix handling of generated columns in ALTER TABLE. · 4ac8aaa3
    Tom Lane authored
    ALTER TABLE failed if a column referenced in a GENERATED expression
    had been added or changed in type earlier in the ALTER command.
    That's because the GENERATED expression needs to be evaluated
    against the table's updated tuples, but it was being evaluated
    against the original tuples.  (Fortunately the executor has adequate
    cross-checks to notice the mismatch, so we just got an obscure error
    message and not anything more dangerous.)
    
    Per report from Andreas Joseph Krogh.  Back-patch to v12 where
    GENERATED was added.
    
    Discussion: https://postgr.es/m/VisenaEmail.200.231b0a41523275d0.16ea7f800c7@tc7-visena
    4ac8aaa3
generated.out 29.7 KB