pgsql: Properly update the 'group' flatfile when modifying the user, in

From: momjian(at)svr1(dot)postgresql(dot)org (Bruce Momjian)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Properly update the 'group' flatfile when modifying the user, in
Date: 2005-10-26 13:43:28
Message-ID: 20051026134328.AAE2DDA262@svr1.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Log Message:
-----------
Properly update the 'group' flatfile when modifying the user, in case
they were added to a group. Also fix visibility of our own changes when
creating the group file. This fixes:

test=> CREATE GROUP g1;
CREATE GROUP

test=> CREATE USER u1 IN GROUP g1;
CREATE USER
test=> \! cat /u/pg/data/global/pg_group
"g1" "u1"

test=> CREATE USER u2 IN GROUP g1;
CREATE USER
test=> \! cat /u/pg/data/global/pg_group
"g1" "u1" "u2"

test=> ALTER USER u2 RENAME TO u3;
ALTER USER
test=> \! cat /u/pg/data/global/pg_group
"g1" "u1" "u3"

[ this code does not exist in CVS head.]

Per report from Dennis Vshivkov

Tags:
----
REL8_0_STABLE

Modified Files:
--------------
pgsql/src/backend/commands:
user.c (r1.147 -> r1.147.4.1)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/user.c.diff?r1=1.147&r2=1.147.4.1)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2005-10-26 19:21:55 pgsql: Adjust parser so that POSTQUEL-style implicit RTEs are stored
Previous Message Bruce Momjian 2005-10-26 13:20:47 pgsql: Update AIX FAQ, backpatch.