non-existent user "28"

From: "Tamsin" <tg_mail(at)bryncadfan(dot)co(dot)uk>
To: "Postgres General" <pgsql-general(at)postgresql(dot)org>
Subject: non-existent user "28"
Date: 2001-03-22 13:28:48
Message-ID: NEBBKHBOBMJCHDMGKCNJMEGMCLAA.tg_mail@bryncadfan.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
when I pg_dump my database, I get lines like:
GRANT SELECT on "tablename" to "28";

When I restore from the dump file, I get errors:
ERROR: aclparse: non-existent user "28"

The dump file does contain grants for the real users which exist in the
database, and I've checked pg_shadow, and there is no user 28.
I'm not sure how the database got in this state - would this happen when I
drop & recreate a user? Is there something I can do about this? I couldn't
see where in the system tables the permission info is stored.

Thanks,
Tamsin

Responses

Browse pgsql-general by date

  From Date Subject
Next Message J.H.M. Dassen Ray 2001-03-22 13:34:44 Re: transaction aborted with error
Previous Message Daniel Francisco Sachet 2001-03-22 13:09:43