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

2012-12-08 Thread me
The following bug has been logged on the website: Bug reference: 7741 Logged by: Nathan Alden, Sr. Email address: m...@nathanalden.com PostgreSQL version: 9.2.2 Operating system: Windows 7 x64 Description: - Create new group role called my_group with default settings

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

2012-12-08 Thread Tom Lane
m...@nathanalden.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!

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

2012-12-08 Thread Tom Lane
I wrote: m...@nathanalden.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