Re: [GENERAL] From: gorman@acheron.franken.de - Mailing list pgsql-general

From Ernst Lehmann
Subject Re: [GENERAL] From: gorman@acheron.franken.de
Date
Msg-id 199904252321.BAA10950@orinoco.franken.de
Whole thread Raw
In response to RE: [GENERAL] From: gorman@acheron.franken.de  (Michael J Davis <michael.j.davis@tvguide.com>)
List 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@acheron.franken.de
Regensburg   ; Germany



pgsql-general by date:

Previous
From: Michael J Davis
Date:
Subject: RE: [GENERAL] From: gorman@acheron.franken.de
Next
From: gorman@acheron.franken.de
Date:
Subject: Re: [GENERAL] From: gorman@acheron.franken.de