Basically our whole API of communicating ACL information to the user is
poor. Look at psql \z:
test=> create table test(x int);
CREATE TABLE
test=> grant all on test to public;
GRANT
test=> \z test
Access privileges for database "test"
Schema | Name | Type | Access privileges
--------+------+-------+------------------------------------------------------
public | test | table | {postgres=a*r*w*d*R*x*t*/postgres,=arwdRxt/postgres}
(1 row)
Do we actually expect folks to understand that? What use is \z really
then? Sure, maybe we document it in the GRANT manual page, but that
hardly makes it readable on its own.
--
Bruce Momjian | http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
