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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
