Re: pgAdmin III does not display Default Privileges for schemas

<div dir="ltr"><div class="gmail_default" style="font-family:tahoma,sans-serif">Hello,</div><div class="gmail_default"
style="font-family:tahoma,sans-serif"><br/></div><div class="gmail_default" style="font-family:tahoma,sans-serif"> I
foundthis thread from 2012 concerning a problem where pgAdmin III doesn't display default privileges for
schemas:</div><divclass="gmail_default" style="font-family:tahoma,sans-serif"><br /></div><div
class="gmail_default"><fontface="tahoma, sans-serif"><a
href="http://www.postgresql.org/message-id/1356354218.2000.30.camel@localhost.localdomain">http://www.postgresql.org/message-id/1356354218.2000.30.camel@localhost.localdomain</a></font><br
/></div><divclass="gmail_default"><font face="tahoma, sans-serif"><br /></font></div><div class="gmail_default"><font
face="tahoma,sans-serif">The thread says the fix has been made, but I just downloaded the latest Windo</font>ws version
(v1.18.1) of pgAdmin III and the problem still seems to be happening. Is the fix not available in this
version?</div><divclass="gmail_default"><br />On Fri, 2012-12-07 at 20:38 -0600, Nathan Alden wrote:<br /><br />>
Windows7 x64<br />> PostgreSQL 9.2.2<br />> pgAdmin III 1.16.1<br />> <br />> Follow these steps to
reproduce:<br/>> <br /> > 1. Connect to the postgres DB.<br />> 2. Run the following SQL:<br />> <br />>
createdatabase test_database;<br />> <br />> 3. Run the following SQL:<br />> <br />> create role
my_group;<br/>> <br />> 4. Connect to the test_database DB.<br /> > 5. Run the following SQL:<br />> <br
/>>alter default privileges in schema public grant all on types to my_group;<br />> <br />> 6. Open pgAdmin
III.<br/>> 7. Navigate to the public schema in test_database.<br /> > 8. Right-click the public schema and choose
Properties.<br/>> 9. Select the Default Privileges tab.<br />> 10. Note that all four subtabs are empty, and the
Roledrop-down lists do<br />> not list my_group as a role.<br /> ><br />> Thanks for your report, it's fixed
now.<br/>><br />><br />>-- <br />>Guillaume<br />><a
href="http://blog.guillaume.lelarge.info">http://blog.guillaume.lelarge.info</a><br/>><a
href="http://www.dalibo.com">http://www.dalibo.com</a><br/><br />Thank you,</div><div class="gmail_default">Shira<br
/><divstyle="font-weight:bold;font-style:normal;font-variant:normal;line-height:20px;margin:0px"><br
style="color:rgb(0,0,0);font-family:Tahoma;font-size:13px;font-weight:normal;line-height:normal"/></div><div
style="font-weight:bold;font-style:normal;font-variant:normal;line-height:20px;margin:0px"><br/></div><div
style="padding-top:8px"> </div></div></div>