[pgAdmin III] #54: Wrong display of privileges on Procedural Language in SQL window

From: "pgAdmin Trac" <trac(at)code(dot)pgadmin(dot)org>
To:
Cc: pgadmin-hackers(at)postgresql(dot)org
Subject: [pgAdmin III] #54: Wrong display of privileges on Procedural Language in SQL window
Date: 2009-09-01 11:57:50
Message-ID: 058.61fac5d12db8cabb8404f4359f84ef73@code.pgadmin.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

#54: Wrong display of privileges on Procedural Language in SQL window
-------------------------------+--------------------------------------------
Reporter: Jan-Peter Seifert | Owner: dpage
Type: bug | Status: new
Priority: minor | Milestone:
Component: pgadmin | Version: 1.10
Keywords: language | Platform: all
-------------------------------+--------------------------------------------
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?

--
Ticket URL: <http://code.pgadmin.org/trac/ticket/54>
pgAdmin III <http://code.pgadmin.org/trac/>
pgAdmin III

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message pgAdmin Trac 2009-09-01 11:58:30 Re: [pgAdmin III] #54: Wrong display of privileges on Procedural Language in SQL window
Previous Message Ashesh Vashi 2009-09-01 11:16:47 Re: PATCH(WIP): Printing Support And Save GQB/Explain as an image