This bug has not been addressed in pgAdmin 1.22.0, yet.If I run this as user postgres:ALTER DEFAULT PRIVILEGES FOR ROLE foo IN SCHEMA test GRANT SELECT ON TABLES TO bar;Then the SQL pane says (still as user postgres):ALTER DEFAULT PRIVILEGES IN SCHEMA test GRANT SELECT ON TABLES TO bar;
Which is incorrect and misleading.
The display of ALTER DEFAULT PRIVILEGES statements can be incorrect.I reported this bug in 2013, but it seems like it never got through:http://www.postgresql.org/message-id/528C2D00.6010905@falter.atDetails, with steps to reproduce:https://redmine.postgresql.org/issues/694Just tested with version 1.20 again and the situation seems unchanged.RegardsErwin
pgadmin-support by date:
Соглашаюсь с условиями обработки персональных данных