Re: BUG #7741: Two bugs when backing up databases with default privileges defined on public schema

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: me(at)nathanalden(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #7741: Two bugs when backing up databases with default privileges defined on public schema
Date: 2012-12-08 16:57:58
Message-ID: 22681.1354985878@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

me(at)nathanalden(dot)com writes:
> alter default privileges in schema public grant all on types to my_group;
> [ leads to ]
> pg_dump: unknown object type (84) in default privileges

Hmm ... looks like whoever added GRANT ON TYPES did a pretty half-baked
job. Will look into it --- thanks for the report!

> - Again in pgAdmin III, right-click the public schema and choose Properties
> - Navigate to the Default Privileges tab and note how no default privileges
> show up, even though they are present

This may be a consequence of the other problem, but in case it isn't,
you should report it on the pgadmin mailing list. pgsql-bugs generally
just deals with bugs in the core Postgres distribution.

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Kevin Grittner 2012-12-08 17:00:06 Re: Migrate Posgresql 8.0.0 beta 5
Previous Message Kevin Grittner 2012-12-08 16:42:41 Re: BUG #7733: support Retina display in pgAdmin