Juan C. Aragon wrote: > Thanks Bruce for replying. > > The ACL is display in the PgAdmin tool for Windows on the properties for a > table or function. ACL is the Privileges. By default, when you create a new > function or table, the ACL is null. However, if you add some privileges, and > then remove all, the ACL is not longer null, it displays the brackets {}.
I can reproduce your reported behavior in psql, which I admit is odd: test=> create table test(x int); CREATE TABLE test=> \pset null '(null)' Null display is "(null)". test=> grant all on test to postgres; GRANT test=> revoke all on test from postgres; REVOKE test=> select relacl from pg_class where relname = 'test'; relacl -------- {} (1 row) Community, do we want to make a permission reset cause the column to become null? > I just need to know if the brackets are normal when all the privileges are > remove. Or how to reset the privileges (ACL) to default (null). They are the same. -- Bruce Momjian <br...@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs