#402 schema owner is blank for role with nologin

5.0-Beta-2
closed-duplicate
Databases (12)
5
2010-10-22
2010-10-22
Sompop
No

phpPgAdmin: 5.0-beta-2, 4.3.2
postgres:8.4.1

Example:
create role abc with nologin;
create schema xxx authorization abc;

Schema owner of schema xxx will be blank.

In getSchemas():
SELECT pn.nspname, pu.usename AS nspowner,
pg_catalog.obj_description(pn.oid, 'pg_namespace') AS nspcomment
FROM pg_catalog.pg_namespace pn
LEFT JOIN pg_catalog.pg_user pu ON (pn.nspowner = pu.usesysid)
ORDER BY nspname

It should be:
SELECT pn.nspname, pu.rolname AS nspowner,
pg_catalog.obj_description(pn.oid, 'pg_namespace') AS nspcomment
FROM pg_catalog.pg_namespace pn
LEFT JOIN pg_catalog.pg_roles pu ON (pn.nspowner = pu.oid)
ORDER BY nspname

Discussion

  • J.Guillaume (ioguix) de Rorthais

    • assigned_to: nobody --> ioguix
    • status: open --> closed-duplicate
     

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks