Re: AW: [HACKERS] Re: [GENERAL] users in Postgresql

Peter Eisentraut <peter_e@gmx.net> writes:
> 5) How exactly are you supposed to set the uid? The behaviour of
> INSERT INTO pg_shadow VALUES (...);
> and
> UPDATE pg_shadow SET usesysid = ...;
> is non-deterministic at best, unfortunately.

INSERT seems to have worked fine in the old version of createuser...
but I agree CREATE/ALTER USER ought to have the same functionality.
        regards, tom lane