Alvaro Herrera <alvhe...@commandprompt.com> writes: > The reason I'm asking is that I'm trying to allow "public" to be passed > to has_table_privileges(), and have it check for the PUBLIC pseudo-role. > Originally I had coded it using pg_strcasecmp() on the grounds that any > case should refer to this.
That would be incorrect, IMO. Ordinary role names passed to that function would certainly not be treated case-insensitively, so this one should not be either. > It seems a complicated rule to document. Seems better to just disallow > creating a role "public" regardless of case. Perhaps, but the above is not a good argument for changing it. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers