• Michael Paquier's avatar
    Fix ALTER DEFAULT PRIVILEGES with duplicated objects · 21378e1f
    Michael Paquier authored
    Specifying duplicated objects in this command would lead to unique
    constraint violations in pg_default_acl or "tuple already updated by
    self" errors.  Similarly to GRANT/REVOKE, increment the command ID after
    each subcommand processing to allow this case to work transparently.
    
    A regression test is added by tweaking one of the existing queries of
    privileges.sql to stress this case.
    
    Reported-by: Andrus
    Author: Michael Paquier
    Reviewed-by: Álvaro Herrera
    Discussion: https://postgr.es/m/ae2a7dc1-9d71-8cba-3bb9-e4cb7eb1f44e@hot.ee
    Backpatch-through: 9.5
    21378e1f
privileges.out 71.3 KB