bug in CREATE USER
Massimo Dal Zotto <dz@cs.unitn.it>
From: Massimo Dal Zotto <dz@cs.unitn.it>
To: hackers@postgreSQL.org (PostgreSQL Hackers)
Date: 1999-01-08T15:58:34Z
Lists: pgsql-hackers
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 |
+----------------------------------------------------------------------+