Re: AW: [HACKERS] Re: [QUESTIONS] groups of users

On Wed, 6 May 1998, Andreas Zeugswetter wrote:

>
> Just tried this out, and we have a bug here:
>
> simply not implemented, not a bug.

Then should generate a NOTICE to that effect...right now, its
misleading unless you go and do a select on pg_group to find that it
wasn't actually performed...

As it stands now, it is a bug...

> template1=> create user tester in group pg_user;
> CREATE USER
>
> so "pg_user" is supposed to be a new group name (not a good name)

Sorry, just picked the first thing that came into my head :)

> The group "pg_user" must already exist. But since the "in group" clause
> is currently ignored, no error shows up.

Why? if group doesn't exist do:

insert into pg_group values ('groname',max(grosysid)+1,'{values}');

> 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
>
> you created a group "test" with one user ("scrappy") as it's only member.
> This is currently the only way to do it.

Unfortunately, the above test was done at home, but here it is
again:

template1=> select * from pg_group;
groname|grosysid|grolist
-------+--------+----------------
pgsql | 0|{10,1044,65534}
banner | 1|{10,65534}
acctng | 2|{0,99,10}
survey | 3|{10,65534,0,206}
(4 rows)

template1=> create user someone in group agroup;
CREATE USER
template1=> select * from pg_group;
groname|grosysid|grolist
-------+--------+----------------
pgsql | 0|{10,1044,65534}
banner | 1|{10,65534}
acctng | 2|{0,99,10}
survey | 3|{10,65534,0,206}
(4 rows)

template1=> create user some in group agroup;
ERROR: defineUser: user "some" has already been created
template1=>

There is no group 'some'...it almost looks like its doing a '~*'
match:

template1=> select usename from pg_user;
usename
--------
scrappy
neil
nobody
darchell
adrenlin
julie
bigtech
news
acctng
root
salesorg
someone
(12 rows)