On Fri, Feb 22, 2013 at 5:55 PM, James B. Byrne <byrnejb@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