two questions about pg 9.0

Поиск
Список
Период
Сортировка
От Kasia Tuszynska
Тема two questions about pg 9.0
Дата
Msg-id 232B5217AD58584C87019E8933556D1102198CA98C@redmx2.esri.com
обсуждение исходный текст
Ответ на Re: build from Source: 9.0.1 / 9.1-alpha1 cannot build modules  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: two questions about pg 9.0  (Guillaume Lelarge <guillaume@lelarge.info>)
Список pgsql-admin
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
willalso have the permission to: "can modify catalog directly", when I look at the sql that is generated by that gui, I
donot 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
therole 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
followingsql:  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


В списке pgsql-admin по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: build from Source: 9.0.1 / 9.1-alpha1 cannot build modules
Следующее
От: Guillaume Lelarge
Дата:
Сообщение: Re: two questions about pg 9.0