bug in CREATE USER

Hi,

it seems that the CREATE USER command doesn't handle the group value at all:

INSERT INTO pg_group VALUES ('todos',100);
CREATE USER miriam IN GROUP todos;
select * from pg_group;
groname|grosysid|grolist
-------+--------+-------
todos | 100|

I would like to have the usesysid of a new user to the grolist of all his
groups. I would also like to have a WITH UID clause in order to be able to
assign an explict uid to the user.

--
Massimo Dal Zotto

+----------------------------------------------------------------------+
| Massimo Dal Zotto email: dz(at)cs(dot)unitn(dot)it |
| Via Marconi, 141 phone: ++39-0461534251 |
| 38057 Pergine Valsugana (TN) www: http://www.cs.unitn.it/~dz/ |
| Italy pgp: finger dz(at)tango(dot)cs(dot)unitn(dot)it |
+----------------------------------------------------------------------+