On Wed, May 4, 2011 at 4:39 PM, Tom Lane <t...@sss.pgh.pa.us> wrote: > "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?
Will commit 2e82d0b396473b595a30f68b37b8dfd41c37dff8 have possibly fixed this? -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
