aclitem out/in don't "work" - Mailing list pgsql-hackers

From Gregory Stark
Subject aclitem out/in don't "work"
Date
Msg-id 87r6eeog4w.fsf@oxford.xeocode.com
Whole thread Raw
Responses Re: aclitem out/in don't "work"  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Just noting what seems to me to be a bug, though perhaps not a consequential
one since we never dump out the contents of system tables and don't expect
people to be using aclitem for non-system tables.

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


I can't look at fixing it right now but I'll poke my nose in a bit later when
I'm done what I'm doing.

--  Gregory Stark EnterpriseDB          http://www.enterprisedb.com Ask me about EnterpriseDB's PostGIS support!


pgsql-hackers by date:

Previous
From: "Jonah H. Harris"
Date:
Subject: Re: Ideas input sought for this year's SOC page
Next
From: Tom Lane
Date:
Subject: Re: [ADMIN] Encoding problems with migration from 8.0.14 to 8.3.0 on Windows