Thread: Group does not exist.

Hello all,

I'm trying to grant select privileges to members of a group.
I created the group (testgroup), added users, and when I

grant select on employee to testgroup;

in psql "ERROR Group testgroup does not exist" is returned.

I've tried this in Xpg, the psql command line, and using DBVisualizer, all
with identical results.
The group is listed in pg_group along with the IDs of the users I wanted
assigned to the group.
I was able to grant the privileges by iterating through the individual
users.

Any help is appreciated.
Bob

I have already answered the author with the fix:

    grant select on employee to group testgroup;

---------------------------------------------------------------------------

Bob Jarman wrote:
> Hello all,
>
> I'm trying to grant select privileges to members of a group.
> I created the group (testgroup), added users, and when I
>
> grant select on employee to testgroup;
>
> in psql "ERROR Group testgroup does not exist" is returned.
>
> I've tried this in Xpg, the psql command line, and using DBVisualizer, all
> with identical results.
> The group is listed in pg_group along with the IDs of the users I wanted
> assigned to the group.
> I was able to grant the privileges by iterating through the individual
> users.
>
> Any help is appreciated.
> Bob
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073