"Tom Lane" <tgl@sss.pgh.pa.us> writes:
> Gregory Stark <stark@enterprisedb.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'sPostgreSQL training!