[Pkg-postgresql-public] pg_dump and removed user ids
Andreas Tille
tillea at rki.de
Mon Aug 21 08:54:07 UTC 2006
Hi,
I removed a certain user ID from my PostgreSQL (7.4, current testing)
server and now an SQL dump created via pg_dump contains lines like
GRANT ALL ON TABLE confidence TO "101";
(the user obviousely had the user usesysid 101 in pg_user which does
not contain such an usesysid any more).
Shouldn't I expect that this usesysid doea not show up in dumps any
more? I would regard this as bug but I want to ask the experts first.
BTW, how can I get rid of these zombie?
Kind regards
Andreas.
--
http://fam-tille.de
More information about the Pkg-postgresql-public
mailing list