• Tom Lane's avatar
    Repair breakage of rules containing INSERT ... SELECT actions, per bug · a51f004d
    Tom Lane authored
    report from Joel Burton.  Turns out that my simple idea of turning the
    SELECT into a subquery does not interact well *at all* with the way the
    rule rewriter works.  Really what we need to make INSERT ... SELECT work
    cleanly is to decouple targetlists from rangetables: an INSERT ... SELECT
    wants to have two levels of targetlist but only one rangetable.  No time
    for that for 7.1, however, so I've inserted some ugly hacks to make the
    rewriter know explicitly about the structure of INSERT ... SELECT queries.
    Ugh :-(
    a51f004d
rewriteDefine.c 12 KB