| From: | gorman(at)acheron(dot)franken(dot)de |
|---|---|
| To: | pgsql-general(at)postgreSQL(dot)org |
| Subject: | Re: [GENERAL] From: gorman@acheron.franken.de |
| Date: | 1999-04-25 23:24:36 |
| Message-ID: | 199904252324.BAA10993@orinoco.franken.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> This should do the trick:
>
> update pg_group set grolist = '{uid1, uis2, uid3}' where grosysid = 1;
> update pg_group set grolist = '{uid4, uis5, uid6}' where grosysid = 2;
>
> where uid1,uid2,uid3 is pg_user.Usesysid for each user in group 1 and
> uid4,uid5,uid6 is pg_user.Usesysid for each user in group 2 and
Oh, thanks a lot. Yes this fixed my trouble. I think this is a problem in
the create user and/or alter user command. Because this command imho has
to enter the group-values in the pg_group table.
Ok, now I now how to make the trick
Thanks for your very fast help to this problem.
--
Bye
Ernst
----
Ernst Lehmann lehmann(at)acheron(dot)franken(dot)de
Regensburg ; Germany
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bob VonMoss | 1999-04-26 01:10:56 | PGSQL/JDBC & browser compatibility |
| Previous Message | Ernst Lehmann | 1999-04-25 23:21:36 | Re: [GENERAL] From: gorman@acheron.franken.de |