Обсуждение: GRANT role docs inconsistency
The manual says: GRANT role [, ...] TO { username | GROUP groupname | PUBLIC } [, ...] [ WITH ADMIN OPTION ] But: postgres=# GRANT test TO GROUP test2; ERROR: syntax error at or near "GROUP" at character 15 LINE 1: GRANT test TO GROUP test2; Either I can't read the docs :-), or the docs are wrong, or the code is wrong... //Magnus
"Magnus Hagander" <mha@sollentuna.net> writes: > The manual says: > GRANT role [, ...] > TO { username | GROUP groupname | PUBLIC } [, ...] [ WITH ADMIN > OPTION ] It doesn't say that anymore: http://archives.postgresql.org/pgsql-committers/2006-08/msg00034.php Perhaps we ought to start thinking about an 8.1 update release --- we haven't had any forcing functions like security issues for awhile, but we've accumulated a fair number of plain ol' bug fixes. regards, tom lane
> > GRANT role [, ...] > > TO { username | GROUP groupname | PUBLIC } [, ...] [ WITH > ADMIN > > OPTION ] > > It doesn't say that anymore: > > http://archives.postgresql.org/pgsql-committers/2006- > 08/msg00034.php > Pfft. I need to remember to check development docs as well :-) sorry about the noise. > Perhaps we ought to start thinking about an 8.1 update release --- > we haven't had any forcing functions like security issues for > awhile, but we've accumulated a fair number of plain ol' bug fixes. If nothing else, it should IMHO be scheduled to happen well before the 8.2 release, simply to "clear the queue" before that one. We can still end up with the need to have an urgent release because of a security issue or something, but it's probably a good idea not to have a scheduled release in the stable branches at the same time as the new major version... //Magnus