"Daniel Grace" <dgr...@wingsnw.com> writes:
> Bug reference: 6005
> Logged by: Daniel Grace
> Email address: dgr...@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
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
