• Tom Lane's avatar
    Fix handling of auto-updatable views on inherited tables. · 5530a826
    Tom Lane authored
    An INSERT into such a view should work just like an INSERT into its base
    table, ie the insertion should go directly into that table ... not be
    duplicated into each child table, as was happening before, per bug #8275
    from Rushabh Lathia.  On the other hand, the current behavior for
    UPDATE/DELETE seems reasonable: the update/delete traverses the child
    tables, or not, depending on whether the view specifies ONLY or not.
    Add some regression tests covering this area.
    
    Dean Rasheed
    5530a826
rewriteHandler.c 91.4 KB