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
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
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