Re: WARNING: group with ID NNN does not exist - Mailing list pgsql-general

From Tom Lane
Subject Re: WARNING: group with ID NNN does not exist
Date
Msg-id 18365.1104359786@sss.pgh.pa.us
Whole thread Raw
In response to WARNING: group with ID NNN does not exist  ("Ed L." <pgsql@bluepolka.net>)
List pgsql-general
"Ed L." <pgsql@bluepolka.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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_dump and pgpool
Next
From: Scott Marlowe
Date:
Subject: Re: pg_dump and pgpool