two questions about pg 9.0

From: Kasia Tuszynska <ktuszynska(at)esri(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: two questions about pg 9.0
Date: 2010-10-12 17:25:55
Message-ID: 232B5217AD58584C87019E8933556D1102198CA98C@redmx2.esri.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers pgsql-admin pgsql-testers

Hi Everybody,

My environment:
Windows 2008 32 bit
Postgres 9.0

I have two unrelated questions:

1. Permissions:
When I create a login role with superuser privileges in pgAdminIII I have the option of indicating that the superuser will also have the permission to: "can modify catalog directly", when I look at the sql that is generated by that gui, I do not see a corresponding sql permission, I see:
"CREATE ROLE kasia LOGIN ENCRYPTED PASSWORD 'md5ff0508b7bb33909c096d1b447a17d09b'
SUPERUSER VALID UNTIL 'infinity';"
A. What does "can modify catalog directly" actually do? I looked it up and I found : "This option determines whether the role can modify system catalog directly or not." But that really does not tell me much.
B. Why is there no sql level equivalent? When I revoke the "can modify catalog directly" permission I get the following sql: UPDATE pg_authid SET rolcatupdate=false WHERE OID=17331::oid;

2. Postgres client dlls on windows
I am trying to identify the dlls that are considered postgres client libraries

In 8.3.8 and 8.4.1 they were:
Libpq.dll, comerr32.dll, gssapi32.dll, k5sprt32.dll, libeay32.dll, libiconv2.dll, libintl3.dll, ssleay32.dll

In 9.0 they seem to be:
Libpq.dll, ssleay32.dll, libeay32.dll, libintl-8.dll - IS THIS CORRECT?
- Looking at the libpq dependencies the rest seem to be windows os dll

Thank you,
Sincerely,
Kasia

In response to

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message Guillaume Lelarge 2010-10-12 17:59:21 Re: two questions about pg 9.0
Previous Message pgAdmin Trac 2010-10-12 15:23:16 [pgAdmin III] #254: Wrong indexes sizes on index page

Browse pgsql-admin by date

  From Date Subject
Next Message Guillaume Lelarge 2010-10-12 17:59:21 Re: two questions about pg 9.0
Previous Message Tom Lane 2010-10-11 23:20:44 Re: build from Source: 9.0.1 / 9.1-alpha1 cannot build modules

Browse pgsql-testers by date

  From Date Subject
Next Message Guillaume Lelarge 2010-10-12 17:59:21 Re: two questions about pg 9.0
Previous Message Tom Lane 2010-10-11 23:20:44 Re: build from Source: 9.0.1 / 9.1-alpha1 cannot build modules