Re: WARNING: group with ID NNN does not exist

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Ed L(dot)" <pgsql(at)bluepolka(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: WARNING: group with ID NNN does not exist
Date: 2004-12-29 22:36:26
Message-ID: 18365.1104359786@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Ed L." <pgsql(at)bluepolka(dot)net> writes:
> I'm getting the following warning on 8.0beta3:
> WARNING: group with ID 103 does not exist
> It is true that I don't have a pg_group.grosysid = 103,
> but I don't understand why the backend expects it in the
> first place.

Probably because you had such a group, and dropped it without first
dropping all the permissions it had. "\z measurement_error" will
likely show a reference to that group.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2004-12-29 22:36:48 Re: pg_dump and pgpool
Previous Message Tom Lane 2004-12-29 22:33:18 Re: pg_dump and pgpool