[EMAIL PROTECTED] writes: > When I do a SELECT * FROM pg_shadow, I can have more than one user > with the same id. This caused the pg_dump to fail. > I read that it happened in v7.1.2 and I am currently using v7.3.2
This is *real* hard to believe. Versions 7.2 and later have a unique index on pg_shadow.usesysid. Are you certain the server isn't 7.1 or older? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])