Re: BUG #6005: ALTER ROLE ... VALID UNTIL 'infinity' crashes postmaster on a fresh install

"Daniel Grace" <dgrace@wingsnw.com> writes:
> Bug reference:      6005
> Logged by:          Daniel Grace
> Email address:      dgrace@wingsnw.com
> PostgreSQL version: 9.1-beta1
> Operating system:   Win7 x64 (x86 postgres)
> Description:        ALTER ROLE ... VALID UNTIL 'infinity' crashes postmaster
> on a fresh install
> Details:

> While trying to restore a database created under 9.1 alpha (created with
> pg_dumpall):

> CREATE ROLE postgres;
> ALTER ROLE postgres WITH SUPERUSER INHERIT CREATEROLE CREATEDB LOGIN
> REPLICATION PASSWORD 'xxxx';
> CREATE ROLE foo;
> ALTER ROLE foo WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB NOLOGIN
> NOREPLICATION VALID UNTIL 'infinity';

> The final statement causes postmaster to crash.

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

            regards, tom lane