Thread: BUG report: role validity term

Hi,

Thanks for reporting this issue.

Yes, this issue has been reported in the pgadmin generals, send some fixes as well. But unfortunately, the fix is not properly working on Mac machine where it's working on other platforms. I am trying to figure that out as soon as possible and send a patch to hackers list.

Dinesh

-- 
Dinesh Kumar

Software Engineer

Ph: +918087463317

Skype ID: dinesh.kumar432

www.enterprisedb.com

Follow us on Twitter
@EnterpriseDB 

Visit EnterpriseDB for tutorials, webinars, whitepapers and more

On Fri, Sep 20, 2013 at 2:59 AM, Bartosz Dmytrak <bdmytrak@gmail.com> wrote:

Hi all,

I've notices small bug with role validity term.

Use case:

• Open properties window for existing role with non existing validity term (valid until infinity);
• DO NOT change anything;
• switch to SQL panel;
• There is SQL similar to: ALTER ROLE myrole VALID UNTIL '2013-09-19 00:00:00';
• this date is also visible under definition tab;
• validity term is automatically overwritten to current date.
  

This scenario is applicable only for users without existing validity date (infinity). If user has any VALID TO date, pgAdmin works fine.

env:

pgAdmin 1.18.0 on Fedora 19 x64

Regards
Bartek