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

"Daniel Grace" <dgrace(at)wingsnw(dot)com> writes:
> Bug reference: 6005
> Logged by: Daniel Grace
> Email address: dgrace(at)wingsnw(dot)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