Re: AW: [HACKERS] Re: [GENERAL] users in Postgresql - Mailing list pgsql-hackers

From Tom Lane
Subject Re: AW: [HACKERS] Re: [GENERAL] users in Postgresql
Date
Msg-id 16351.942356199@sss.pgh.pa.us
Whole thread Raw
In response to Re: AW: [HACKERS] Re: [GENERAL] users in Postgresql  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: failure of \e in psql
Next
From: Bruce Momjian
Date:
Subject: Re: failure of \e in psql