Tom,
I'm also seeing that the DEFAULT PRIVs I get seem to be dependant on my
login role, not my current role. That is, if role "dba" has default
privs set, and role "josh", which is a member of "dba" does not, and
"josh" does "set role dba" before creating some tables, those tables do
NOT get dba's default privs. At least, that's what happens in my testing.
Is that expected? If so, that should certainly be documented.
--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com