Re: BUG #6005: ALTER ROLE ... VALID UNTIL 'infinity' crashes postmaster on a fresh install - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #6005: ALTER ROLE ... VALID UNTIL 'infinity' crashes postmaster on a fresh install
Date
Msg-id 20377.1305146201@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #6005: ALTER ROLE ... VALID UNTIL 'infinity' crashes postmaster on a fresh install  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-bugs
Robert Haas <robertmhaas@gmail.com> writes:
> On Wed, May 4, 2011 at 4:39 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> "Daniel Grace" <dgrace@wingsnw.com> writes:
>>> ALTER ROLE foo WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB NOLOGIN
>>> NOREPLICATION VALID UNTIL 'infinity';

>> Hmm, cannot duplicate this here ... can anyone else?  Windows-specific
>> issue perhaps?

> Will commit 2e82d0b396473b595a30f68b37b8dfd41c37dff8 have possibly fixed this?

It will have stopped the crash, but no more.  See
http://archives.postgresql.org/pgsql-hackers/2011-05/msg00589.php

Working on the rest of the fix now.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Robert Haas
Date:
Subject: Re: BUG #6005: ALTER ROLE ... VALID UNTIL 'infinity' crashes postmaster on a fresh install
Next
From: Tom Lane
Date:
Subject: Re: BUG #6005: ALTER ROLE ... VALID UNTIL 'infinity' crashes postmaster on a fresh install