I am running PostgreSQL 6.4.2 with no modifications.
I recently had the opportunity to load one of my databases from backup
(oops), and it worked just fine except for the fact that my
permissions didn't get updated correctly despite the fact that I
dumped them with pg_dump -z. Basically I have a group that I want to
grant access to, but all I got was a succession of errors like the
following one:
\connect - postgres
CREATE SEQUENCE "u_id_seq" start 1075 increment 1 maxvalue 2147483647 minvalue 1
cache 1 ;
QUERY: CREATE SEQUENCE "u_id_seq" start 1075 increment 1 maxvalue 2147483647 minvalue
1 cache 1 ;
SELECT nextval ('u_id_seq');
QUERY: SELECT nextval ('u_id_seq');
connecting as new user: postgres
CREATE
nextval
-------
1075
(1 row)
REVOKE ALL on "u_id_seq" from PUBLIC;
QUERY: REVOKE ALL on "u_id_seq" from PUBLIC;
GRANT ALL on "u_id_seq" to "group helpdesk";
QUERY: GRANT ALL on "u_id_seq" to "group helpdesk";
ERROR: aclparse: mode change flag must use "+-="
This is just an example, all of my relationships had the same
ERROR: aclparse: mode change flag must use "+-="
What does this mean, and where can I read more about it? It's not a
big deal now, as I already have a sql script that will set my
permissions up correctly. Last time I re-loaded my database I learned
about the -z flag for pg_dump :).
Thanks for the help,
Jason Earl
