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
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 |
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 |
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 |