Inconsistency in ACL error message - Mailing list pgsql-hackers

From Joseph Koshakow
Subject Inconsistency in ACL error message
Date
Msg-id CAAvxfHfJuAaKXVTQ7e3EdDko=qyEh-GwgZe_RqzK9MWgcxp9Xw@mail.gmail.com
Whole thread Raw
Responses Re: Inconsistency in ACL error message
List pgsql-hackers
Hi all,

I noticed a very minor inconsistency in some ACL error messages. When
you are try and alter a role, it just says "permission denied":

  postgres=> ALTER ROLE bar NOCREATEDB;
  ERROR:  permission denied
  postgres=> ALTER ROLE bar SET search_path TO 'foo';
  ERROR:  permission denied

For almost all other ACL error, we include what the action was. For
example:

  postgres=> CREATE ROLE r;
  ERROR:  permission denied to create role
  postgres=> DROP ROLE postgres;
  ERROR:  permission denied to drop role
  postgres=> CREATE DATABASE foo;
  ERROR:  permission denied to create database


It's not a huge deal, but it's easy enough to fix that I thought I'd
generate a patch (attached). Let me know if people think that it's
worth merging.

- Joe Koshakow
Attachment

pgsql-hackers by date:

Previous
From: Sébastien Lardière
Date:
Subject: Re: Timeline ID hexadecimal format
Next
From: Matthias van de Meent
Date:
Subject: Re: PATCH: Using BRIN indexes for sorted output