Tim Uckun wrote: >>> drop role tim; >>> ERROR: role "tim" cannot be dropped because some objects depend on it >>> DETAIL: owner of default privileges on new relations belonging to >>> role tim in schema strongmail >> >> DROP OWNED BY ought to get rid of that. > > > Just to be clear. > > I don't want to drop the schema. Will DROP OWNED BY only drop the > priviliege or the schema?
It will not drop the schema unless the schema is owned by the role you are dropping. Yours, Laurenz Albe -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
