Re: Allow non-superuser to cancel superuser tasks. - Mailing list pgsql-hackers

Update - the condition should be && 

    if (pgstat_get_backend_type(proc->backendId) == B_AUTOVAC_WORKER)
    {
        if (!has_privs_of_role(GetUserId(), ROLE_PG_SIGNAL_AUTOVACUUM) && !superuser())
            return SIGNAL_BACKEND_NOAUTOVACUUM;
    }

Thanks
--
Anthony Leung
Amazon Web Services: https://aws.amazon.com