We are aware of the GROUP permissions problem, and hope to have it fixed
in 6.5 final.
>
> 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
>
>
--
Bruce Momjian | http://www.op.net/~candle
[EMAIL PROTECTED] | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
