Re: Extensions and roles for access administration

From: Виктор Егоров <vyegorov(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Extensions and roles for access administration
Date: 2012-06-22 19:18:49
Message-ID: CAGnEbogJXQgNkxj-L9Sb+LehY=TdUg7XzCNgf0s2AvD-UbUpZA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thanks, this clarifies things for me.

There's DROP ROLE IF EXISTS, which I'm using.

2012/6/22 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
>
> 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 :-(
>

--
Victor Y. Yegorov

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2012-06-22 19:44:15 Re: insert select fails inside of function
Previous Message Benedict Holland 2012-06-22 19:01:49 insert select fails inside of function