From: | Gregory Stark <stark(at)enterprisedb(dot)com> |
---|---|
To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | "pgsql-hackers list" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: aclitem out/in don't "work" |
Date: | 2008-03-13 20:24:17 |
Message-ID: | 877ig6tlse.fsf@oxford.xeocode.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
"Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:
> Gregory Stark <stark(at)enterprisedb(dot)com> writes:
>> The output of aclitem can't be read back back in as an aclitem:
>
>> postgres=# select relacl::text from pg_class limit 1;
>> relacl
>> ------------
>> {=r/stark}
>> (1 row)
>
>> postgres=# select relacl::text::aclitem from pg_class limit 1;
>> ERROR: unrecognized key word: ""
>> HINT: ACL key word must be "group" or "user".
>
> relacl is aclitem[] not aclitem. The error message could perhaps be
> improved, but I'm not sure that it's an urgent problem...
oh, doh.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Get trained by Bruce Momjian - ask me about EnterpriseDB's PostgreSQL training!
From | Date | Subject | |
---|---|---|---|
Next Message | James Mansion | 2008-03-13 22:14:18 | Re: Proposal for db level triggers |
Previous Message | Tom Lane | 2008-03-13 20:20:30 | Re: pg_total_relation_size() and CHECKPOINT |