• Alvaro Herrera's avatar
    Avoid duplicates in ALTER ... DEPENDS ON EXTENSION · 899a04f5
    Alvaro Herrera authored
    If the command is attempted for an extension that the object already
    depends on, silently do nothing.
    
    In particular, this means that if a database containing multiple such
    entries is dumped, the restore will silently do the right thing and
    record just the first one.  (At least, in a world where pg_dump does
    dump such entries -- which it doesn't currently, but it will.)
    
    Backpatch to 9.6, where this kind of dependency was introduced.
    
    Reviewed-by: Ibrar Ahmed, Tom Lane (offlist)
    Discussion: https://postgr.es/m/20200217225333.GA30974@alvherre.pgsql
    899a04f5
test_extdepend.out 5.78 KB