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 - Create a new database called test_database with default settings - Run the following SQL: alter default privileges in schema public grant all on tables to my_group; alter default privileges in schema public grant all on functions to my_group; alter default privileges in schema public grant all on sequences to my_group; alter default privileges in schema public grant all on types to my_group; - Using pgAdmin III, backup the test_database database using the plain format and note the error. Here's the log: C:/Program Files/PostgreSQL/9.2/bin\pg_dump.exe --host localhost --port 5432 --username "postgres" --no-password --format plain --verbose --file "D:\Databases\PostgreSQL Backups\test_database.backup" "test_database" pg_dump: reading schemas pg_dump: reading user-defined tables pg_dump: reading extensions pg_dump: reading user-defined functions pg_dump: reading user-defined types pg_dump: reading procedural languages pg_dump: reading user-defined aggregate functions pg_dump: reading user-defined operators pg_dump: reading user-defined operator classes pg_dump: reading user-defined operator families pg_dump: reading user-defined text search parsers pg_dump: reading user-defined text search templates pg_dump: reading user-defined text search dictionaries pg_dump: reading user-defined text search configurations pg_dump: reading user-defined foreign-data wrappers pg_dump: reading user-defined foreign servers pg_dump: reading default privileges pg_dump: reading user-defined collations pg_dump: reading user-defined conversions pg_dump: reading type casts pg_dump: reading table inheritance information pg_dump: reading rewrite rules pg_dump: finding extension members pg_dump: finding inheritance relationships pg_dump: reading column info for interesting tables pg_dump: flagging inherited columns in subtables pg_dump: reading indexes pg_dump: reading constraints pg_dump: reading triggers pg_dump: reading large objects pg_dump: reading dependency data pg_dump: saving encoding = UTF8 pg_dump: saving standard_conforming_strings = on pg_dump: saving database definition pg_dump: unknown object type (84) in default privileges Process returned exit code 1. - 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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs