General Bug Report: "Create User TestUser IN GROUP group_name" does not add the user to the group.

============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================

Your name : Michael Davis
Your email address : mdavis(at)sevainc(dot)com

Category : runtime: back-end
Severity : serious

Summary: "Create User TestUser IN GROUP group_name" does not add the user to the group.

System Configuration
--------------------
Operating System : Red Hat 5.1

PostgreSQL version : 6.5-990428

Compiler used : gcc version 2.7.2.3

Hardware:
---------
Dual Pentium II, 128M RAM
Linux linus 2.0.34 #12 Tue Oct 6 23:24:13 MDT 1998 i686 unknown

Versions of other tools:
------------------------

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

Problem Description:
--------------------
The command "Create User TestUser IN GROUP group_name" does not add the user to the group. You have to " UPDATE pg_group set grolist = '{501,514,502,503,504}' where grosysid = 1;" to get groups to work. The create user should automatically add the user to the grolist of pg_group when the GROUP clause is used.

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

Test Case:
----------
Create User TestUser IN GROUP group_name;
Grant all on table_name to group group_name;
log on as TestUser;
update table_name; and you should see a permission problem.

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

Solution:
---------

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