Re: pg admin 92 beta 3 - bug report - row number 19 is out of range 0..18

Hi

On Fri, Feb 22, 2013 at 3:37 PM, James B. Byrne <byrnejb(at)harte-lyne(dot)ca> wrote:
>
> On Fri, February 22, 2013 09:09, Dave Page wrote:
>
>>
>> Thanks - turning on notices was the key to finding this. I've
>> committed a fix for 1.16.2 and later.
>>
>
> Glad I was of some help.
>
> I have another anomaly to report as well:
>
> OS: CentOS-6.3
> Arch: x86_64
> pgadmin3_92.x86_64 1.16.1-4.rhel6 @pgdg92
> postgresql92-server.x86_64 9.2.3-2PGDG.rhel6 @pgdg92
>
> The owner of the plpgsql language extension is not shown in the
> properties window of that object when it is included in a database.
> The owner property is always blank no matter which user id actually
> owns it. This is true for template1 and any user database.

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

> Also, is there a reason that template0 elements are not available for
> display or manipulation from pgadmin3 when they are in psql?

They're not available in any client unless you've been playing with
the default catalog entries. As a general rule template0 should never
be touched - it's your last chance way to create a completely clean
database.

Here's what happens if you try to access template0 in a default configuration:

postgres=# \connect template0
FATAL: database "template0" is not currently accepting connections
Previous connection kept
postgres=#

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company