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

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