Re: aclitem out/in don't "work"

"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!