[Pkg-postgresql-public] pg_dump and removed user ids

Andreas Tille tillea at rki.de
Mon Aug 21 08:54:07 UTC 2006


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



More information about the Pkg-postgresql-public mailing list