Re: Extensions and roles for access administration - Mailing list pgsql-general

=?UTF-8?B?0JLQuNC60YLQvtGAINCV0LPQvtGA0L7Qsg==?= <vyegorov@gmail.com> writes:
> - I've noticed, that after I DROP EXTENSION, all roles are still there in
> the database. Is this expected?

Roles are not considered to be part of an extension: they really can't
be, since an extension is local to a database while a role is global to
the whole installation.  As per the documentation, you're allowed to do
CREATE ROLE in an extension script but it won't be managed by the
extension mechanism.

Not sure about a better solution to your problem offhand.  It might be
sane for the script to do CREATE ROLE IF NOT EXISTS, if we had that,
which we do not :-(

            regards, tom lane