Re: Can I check if somebody is superuser in stored procedure?

Hello

2011/3/28 David Fetter <david(at)fetter(dot)org>:
> On Sun, Mar 27, 2011 at 03:21:18PM +0200, Pavel Stehule wrote:
>> Hello
>>
>> Is there some simple possibility to check a rights from stored procedure?
>
> Well, there's the catalog lookup method:
>
> SELECT EXISTS (SELECT 1 FROM pg_catalog.pg_roles WHERE rolname=$1 AND rolsuper)
>
> Is that what you had in mind?

I found this too, but it isn't what I searched - I searched a some
exported function based on internal cache.

For my purpose is this solution enough.

Regards

Pavel

>
> Cheers,
> David.
> --
> David Fetter <david(at)fetter(dot)org> http://fetter.org/
> Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
> Skype: davidfetter      XMPP: david(dot)fetter(at)gmail(dot)com
> iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics
>
> Remember to vote!
> Consider donating to Postgres: http://www.postgresql.org/about/donate
>