Re: [BUGS] Bug#333854: pg_group file update problems

2005-10-14 Thread Bruce Momjian
Tom Lane wrote: > Dennis Vshivkov <[EMAIL PROTECTED]> 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 a

Re: [BUGS] Bug#333854: pg_group file update problems

2005-10-14 Thread Tom Lane
Dennis Vshivkov <[EMAIL PROTECTED]> 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 dire

[BUGS] Bug#333854: pg_group file update problems

2005-10-14 Thread Dennis Vshivkov
Package: postgresql-8.0 Version: 8.0.3-13 Severity: important Tags: patch, upstream Here's the problem: db=# CREATE GROUP g1; CREATE GROUP db=# CREATE USER u1 IN GROUP g1;(1) CREATE USER # cat /var/lib/postgresql/8.0/main/global/pg_group # The file gets rewritten, but th