Re: Postgre7.0.2 drop user bug

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Matthew <matt(at)ctlno(dot)com>
Cc: hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Postgre7.0.2 drop user bug
Date: 2000-10-19 04:02:56
Message-ID: 7628.971928176@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Matthew <matt(at)ctlno(dot)com> writes:
>> Anyway, any comments? Can anyone else repeat this? I hope this is easy to
>> fix. I guess the quick fix is to disallow multiple users to be specified
>> in the drop user command.

The correct fix is CommandCounterIncrement() in the DROP USER loop,
so that later iterations can see the changes made by prior iterations.
Without, death and destruction ensue if any of the users are in the
same groups, because the later AlterGroup calls fail.

Fixed in current and back-patched for 7.0.3.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2000-10-19 04:22:58 Re: time stops within transaction
Previous Message Hiroshi Inoue 2000-10-19 03:48:09 Re: time stops within transaction