Re: Bug#333854: pg_group file update problems

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Dennis Vshivkov <walrus(at)amur(dot)ru>, 333854(at)bugs(dot)debian(dot)org
Cc: pgsql-bugs(at)postgreSQL(dot)org
Subject: Re: Bug#333854: pg_group file update problems
Date: 2005-10-14 15:23:56
Message-ID: 10086.1129303436@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-patches

Dennis Vshivkov <walrus(at)amur(dot)ru> writes:
> The problem is that the code that updates pg_group file resolves
> group membership through the system user catalogue cache.

Good catch.

> The attached `98-6-pg_group-stale-data-fix.patch' makes the code
> in question access the system user table directly and thus fixes

Wouldn't a CommandCounterIncrement be a much simpler solution?

Since this code is all gone in CVS tip, there's not going to be any way
of beta-testing a large patch ... and there's also not going to be a lot
of support for pushing a large, poorly tested patch into the back
branches.

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Karl O. Pinc 2005-10-14 15:24:28 Re: BUG #1956: Plpgsql top-level DECLARE does not share
Previous Message Tom Lane 2005-10-14 15:13:11 Re: BUG #1964: Role membership error

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2005-10-14 15:29:30 Re: Bug#333854: pg_group file update problems
Previous Message Michael Meskes 2005-10-14 13:45:56 Re: BUG #1962: ECPG and VARCHAR