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 the report! Ugh ... there were more creepy-crawlies under that rock than I expected. I've squashed a bunch of them: http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=6cb8c6043ee47ced46da131bc0705e9c4bdd8667 but I wouldn't really want to bet that I didn't miss anything. If you have the ability to apply patches locally, please apply that one and keep testing. If not, I'd recommend staying away from datatype privileges until 9.2.3 is out ... 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
