Thread: Wrong display of privileges on Procedural Language in SQL window

Hello,

there seems to be a problem with evaluating the ACL for a procedural language:

SQL windows says:
-- Language: plpgsql

-- DROP LANGUAGE plpgsql;
CREATE TRUSTED PROCEDURAL LANGUAGE 'plpgsql' HANDLER plpgsql_call_handler VALIDATOR plpgsql_validator;
ALTER LANGUAGE plpgsql OWNER TO user1;
REVOKE ALL ON LANGUAGE plpgsql FROM public;
REVOKE ALL ON LANGUAGE plpgsql FROM user2;
REVOKE ALL ON LANGUAGE plpgsql FROM user3;


The ACL in the properties window seems to say correctly:
{=U/user1,user2=U*/user1,user3=U/user1}

Happened to me on PostgreSQL 8.3.7 and pgAdmin 1.8.4/1.10.0.

Thank you very much,

Peter

P.S. Is the "=U/user1" at the beginning the entry for public?
-- 
Jetzt kostenlos herunterladen: Internet Explorer 8 und Mozilla Firefox 3 -
sicherer, schneller und einfacher! http://portal.gmx.net/de/go/atbrowser

On Wed, Aug 5, 2009 at 2:27 PM, Jan-Peter
Seifert<Jan-Peter.Seifert@gmx.de> wrote:
> Hello,
>
> there seems to be a problem with evaluating the ACL for a procedural language:

Thanks - Sachin Srivastava has written a patch for this, and I've
committed it for 1.10.1.

-- 
Dave Page
EnterpriseDB UK:   http://www.enterprisedb.com