On Fri, Feb 22, 2013 at 5:55 PM, James B. Byrne <byrn...@harte-lyne.ca> wrote: > On Fri, February 22, 2013 11:45, Dave Page wrote: > >> >> I see the owner here. What does the following query return for you? >> >> SELECT lan.oid, lan.lanname, lanpltrusted, lanacl, hp.proname as >> lanproc, vp.proname as lanval, description, >> pg_get_userbyid(lan.lanowner) as languageowner >> FROM pg_language lan >> JOIN pg_proc hp on hp.oid=lanplcallfoid >> LEFT OUTER JOIN pg_proc vp on vp.oid=lanvalidator >> LEFT OUTER JOIN pg_description des ON des.objoid=lan.oid AND >> des.objsubid=0 >> WHERE lanispl IS TRUE >> ORDER BY lanname >> > > gives: > > 21117;"plpgsql";t;"";"plpgsql_call_handler";"plpgsql_validator";"PL/pgSQL > procedural language";"hll_theheart_db_devl" > > Which is the same thing I get in psql, so not much of a suprise there. > > However, I was referring to the Extensions Property Window display > contents. This shows the owner column empty for the plpgsql language > in the upper right pane; as shown in the attached screen shot.
Ahh, gotcha. Thanks - fixed. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
