Thread

bug in CREATE USER

Massimo Dal Zotto <dz@cs.unitn.it> — 1999-01-08T15:58:34Z

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@cs.unitn.it               |
|  Via Marconi, 141                phone: ++39-0461534251              |
|  38057 Pergine Valsugana (TN)      www: http://www.cs.unitn.it/~dz/  |
|  Italy                             pgp: finger dz@tango.cs.unitn.it  |
+----------------------------------------------------------------------+