Re: Incorrect error message in InitializeSessionUserId - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: Incorrect error message in InitializeSessionUserId
Date
Msg-id CAB7nPqSOxav0=5fuabyP2WJ78VoEnSCCj_-kCjQDbWLjsZ3Jhw@mail.gmail.com
Whole thread Raw
In response to Re: Incorrect error message in InitializeSessionUserId  (Haribabu Kommi <kommi.haribabu@gmail.com>)
Responses Re: Incorrect error message in InitializeSessionUserId  (Robert Haas <robertmhaas@gmail.com>)
Re[2]: [HACKERS] Incorrect error message in InitializeSessionUserId  (Dmitriy Sarafannikov <d.sarafannikov@bk.ru>)
List pgsql-hackers
On Fri, Mar 4, 2016 at 10:45 AM, Haribabu Kommi
<kommi.haribabu@gmail.com> wrote:
> On Wed, Mar 2, 2016 at 12:21 AM, Dmitriy Sarafannikov
> <d.sarafannikov@bk.ru> wrote:
>> Hi all,
>>
>> I have found incorrect error message in InitializeSessionUserId function
>> if you try to connect to database by role Oid (for example
>> BackgroundWorkerInitializeConnectionByOid).
>> If role have no permissions to login, you will see error message like this:
>> FATAL:  role "(null)" is not permitted to log in
>>
>> I changed few lines of code and fixed this.
>> Patch is attached.
>> I want to add this patch to commitfest.
>> Any objections?
>>
>
> The patch adds the support of taking the role name from the role tuple
> instead of using the provided rolename variable, because it is possible
> that rolename variable is NULL if the connection is from a background
> worker.
>
> The patch is fine, I didn't find any problems, I marked it as ready for
> committer.
>
> IMO this patch may need to backpatch supported branches as it is
> a bug fix. Committer can decide.

+1 for the backpatch. The current error message should the rolename be
undefined in this context is misleading for users.
-- 
Michael



pgsql-hackers by date:

Previous
From: David Rowley
Date:
Subject: Re: WIP: Upper planner pathification
Next
From: Alvaro Herrera
Date:
Subject: Re: pgbench stats per script & other stuff