
Responded to pgsql-hackers...

On Tue, 5 May 1998, Jonathan Sand wrote:

> The 'create user' command allows a group to be specified. How do I create 
> a postgres group to which postgres users can belong? I've scanned the 
> lists and man pages exhaustively. Must be obvious, but I haven't figured 
> it out.
> 
> Jonathan Sand
> 
> sand@gizmolab.com
> 
> Hardware: n. that aspect of a computer system which can be hit.
>

Just tried this out, and we have a bug here:

template1=> create user tester in group pg_user;
CREATE USER
template1=> select * from pg_group;
groname|grosysid|grolist
-------+--------+-------
(0 rows)

template1=> select * from pg_user; 
usename|usesysid|usecreatedb|usetrace|usesuper|usecatupd|passwd  |valuntil                    
-------+--------+-----------+--------+--------+---------+--------+----------------------------
pgsql  |    1005|t          |t       |t       |t        |********|Sat Jan 31 02:00:00 2037 AST
scrappy|      10|t          |t       |t       |t        |********|                            
tester |    1006|f          |t       |f       |t        |********|                            
(3 rows)

template1=> insert into pg_group values ('test',0,'{scrappy}');
ERROR:  pg_atoi: error in "scrappy": can't parse "scrappy"
template1=> insert into pg_group values ('test',0,'{10}');
INSERT 18497 1
template1=> create user test in group pg_user;
ERROR:  defineUser: user "test" has already been created
template1=> create user test in group test;   
ERROR:  defineUser: user "test" has already been created
template1=> select * from pg_user;
usename|usesysid|usecreatedb|usetrace|usesuper|usecatupd|passwd  |valuntil                    
-------+--------+-----------+--------+--------+---------+--------+----------------------------
pgsql  |    1005|t          |t       |t       |t        |********|Sat Jan 31 02:00:00 2037 AST
scrappy|      10|t          |t       |t       |t        |********|                            
tester |    1006|f          |t       |f       |t        |********|                            
(3 rows)

If I do a different usename ('beater'), it creates fine, but doesn't go 
anywhere as far as pg_group...

If nobody is working on this area of the code, I'll use it as my personal
starting point into it...just let me know...
 

Marc G. Fournier                                
Systems Administrator @ hub.org 
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org 


Tue, 5 May 1998 17:36:47 -0300 (ADT)
The Hermit Hacker <scrappy@hub.org>
Re: [QUESTIONS] groups of users