Magnus Hagander <mag...@hagander.net> writes: > Is there any particular reason why we can't/don't auto-create schema > bar when you run "CREATE EXTENSION foo SCHEMA bar"?
That was considered, and rejected for reasons that I probably don't recall all of, but I do remember one argument: 99.44% of the time you want an extension to be in a schema that has public USAGE rights. Having the CREATE EXTENSION command auto-create the schema would be of little value unless it also auto-granted that right, and that didn't seem like a good idea. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers